General-Functions COALESCE IF-ELSEIF-ENDIF
range-locks isolation non-repeatable-reads phantom-read transactions
join inner-join
sub-queries correlated-subquery synchronized-subquery
CREATE-statement DESC-command
limit-keyword TOP-clause ROWNUM
ROWNUM Oracle
HAVING-clause GROUP-BY-clause aggregate-functions
sub-queries