General-Functions COALESCE IF-ELSEIF-ENDIF
non-repeatable-reads range-locks isolation transactions phantom-read
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