Welcome My Blog

Ramdhani Purnama Alam

AINK BOBOTOH PERSIB

Photobucket

Sabtu, 23 April 2011

Praktikum 6

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

0 comment:

Posting Komentar

Get Paid