Select

·       Mathematics

·       Comparison

·       NULL values

·       Column Aliases

·       Concatenation

·       DISTINCT

·       WHERE Clause

·       BETWEEN

·       IN

·       LIKE

·       ALL

·       ANY

·       ORDER BY clause

·       CASE

·       Substitution Variables

·       PIVOT

·       UNPIVOT

·       WITH clause

·       MERGE

·       NVL

·       NVL2

·       AND

·       OR