Managing Objects with Data Dictionary Views

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

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