Minggu, 24 April 2011 di 00.44 | 0 komentar  
Creation of array columns

1.




Large Objects (BLOBs)

1.







2.







3.







4.







Subqueries can replace some joins

1.




2.




Correlated subquery

1.





2.






NOT IN and Subqueries with NULL Values

1.





2.





Customers who have no orders

1.




IN query rewritten using ANY and EXISTS

1.





2.





3.





NOT IN query rewritten using ALL and EXISTS

1.




2.




3.




Simulating outer joins

1.





Subqueries with UPDATE and DELETE

1.







2.










3.







Using SELECT with INSERT

1.












terima kasiih
Diposting oleh AHMAD SANUSI
Jumat, 22 April 2011 di 09.24 | 0 komentar  
aggregates and null values in modul 3


1.






2.





3.






4.






5.






6.


7.





8.





9.
Diposting oleh AHMAD SANUSI
three-table join

1.




four-table join

1.






Employees who have taken orders for customers

1.






2.






Modul 4

contoh penggunaan sequence

1.
















2.












3.









Null values and b,ank strings

1.







2.











using default values
1.



2.



3.
Diposting oleh AHMAD SANUSI
Tugas basis data

join table
Creation of comany tables

1.





2.


3.



4.



insertion into company tables

5.


6.


7.


8.



Finding a cutomer name using two quieries

1.




2.




Finding a cutomer name using two quiry

1.




finding an order number for a customer name

1.
Diposting oleh AHMAD SANUSI
Visit the Site
MARVEL and SPIDER-MAN: TM & 2007 Marvel Characters, Inc. Motion Picture © 2007 Columbia Pictures Industries, Inc. All Rights Reserved. 2007 Sony Pictures Digital Inc. All rights reserved. blogger templates