Retrieving and Sorting Data

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

Single-row SQL Functions Character Functions Number Functions Working with dates Date Functions

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