Using Single – Row Function

Basic SELECT statement Arithmetic expressions and NULL values Column alias Concatenation operator Literal character string Alternative quote operator DISTINCT keyword DESCRIBE command

Limit the retrieve rows Sort the rows Substitution variables

Implicit and explicit data type conversion TO_CHAR, TO_DATE, TO_NUMBER functions Nested Functions General Functions CASE and DECODE Conditional expressions