CREATION OF ARRAY COLUMNS
LARGE OBJECTS (BLOBS)
SUBQUERIES CAN REPLACE SOME JOINS
CORRELATED SUBQUERY
NOT IN AND SUBQUERIES WITH NULL VALUES
EMPLOYEES WHO TOOK ORDERS
CUSTOMERS WHO HAVE NO ORDERS
IN QUERY REWRITTEN USING ANY AND EXISTS
NOT IN QUERY REWRITTEN USING ALL AND EXISTS
SIMULATING OUTER JOINS
SUBQUERIES WITH UPDATE AND DELETE
UPDATE THE ORDER_DATE
USING SELECT WITH INSERT
TABLE CREATION WITH SELECT
