Senin, 25 April 2011

bab 6

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 



Tidak ada komentar:

Posting Komentar