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