WHERE-clause DELETE-statement
Oracle NULL-values General-Functions NVL
CASE-Function
SELECT-clause INSERT-statement
join cross-join inner-join
isolation transactions range-locks phantom-read non-repeatable-reads
ROWNUM Oracle
CREATE-statement
sub-queries
SELECT-clause