1. Membuat tabel array_test
2. Insert data array_tes dan select * from array_test;
3. Select col1[4] from array_test;
4. Select col2[2][1] from array_test;
5. Select col3[1][2][2] from array_test;
6. Hasil nama customer
7. Hasil nama customer
8. Correlated subquery
9. Correlated subquery
10. NOT IN and Subqueries with NULL Values
11. NOT IN and Subqueries with NULL Values
12. NOT IN and Subqueries with NULL Values
13. NOT IN and Subqueries with NULL Values
14. NOT IN and Subqueries with NULL Values
15. NOT IN and Subqueries with NULL Values
16. NOT IN query rewritten using ALL and EXISTS
17. NOT IN query rewritten using ALL and EXISTS
18. NOT IN query rewritten using ALL and EXISTS
19. Simulating outer joins
20. Subqueries with UPDATE and DELETE
21. Subqueries with UPDATE and DELETE
22. Subqueries with UPDATE and DELETE
23. Using SELECT with INSERT
24. Table creation with SELECT
25. Table creation with SELECT
Sabtu, 23 April 2011
Langganan:
Posting Komentar (Atom)
0 comment:
Posting Komentar