Suppressing Duplicate Rows In Output : Until it is instructed sql * plus displays the results of a query without eliminating duplicate rows.To eliminate the duplicate rows in the results, the DISTINCT keyword is used.Multiple columns can be declared...

A literal and constant value are synonyms to one another and refer to a fixed data value. The types of literals recognized by oracle are Text literals Integer literals Number literals Interval literals Text Literals : It specifies a text or character...

Applying Concatenation Operator : The concatenation operator links column to other columns, arithmetic expressions, constant values.Columns on either side of the operator are combined to make a single output column.The resultant column is treated as...

Applying Arithmetical Operations In Select Statements : 1. Arithmetic expressions can be implemented through SELECT statement. 2. Arithmetic expressions can be implemented to Modify the way the data is displayed. Perform calculations. Implement WHAT...

NULL : It is a value which is Unavailable Unassigned U... NULL is not same as zero or blank space. If a row lacks the data for a particular column, than that value is said to be NULL or to contain NULL. SQL>SELECT Ename, Job, Sal, Comm FROM Emp; If...