sub-queries
DROP-statement
Oracle NULL-values General-Functions NVL
constraints CHECK-constraint
WHERE-clause DELETE-statement
TRUNCATE-TABLE
General-Functions COALESCE IF-ELSEIF-ENDIF
INSERT-statement
join cross-join inner-join
NULL-values unique-key primary-key constraints