This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10 g , and free code will be available for download.
This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10 g , and free code will be available for download.
Jason Price (Castro Valley, CA) has over 10 years experience in the software industry, 5 of which were spent at Oracle. Jason is an Oracle Certified Professional DBA and Application Developer and has written several books: Java Programming with Oracle SQLJ, O'Reilly (2001) Oracle9i JDBC Programming, Oracle Press (2002) Mastering Visual C# .NET, Sybex (2002) Mastering Visual C# .NET Database Programming, Sybex (2003.
Inhaltsangabe
Ch. 1: Introduction Ch. 2: Retrieving Information from Tables Ch. 3: Using Simple Functions Ch. 4: Storing and Processing Dates and Times Ch. 5: Using SQL Plus Ch. 6: Subqueries Ch. 7: Advanced Select Functions Ch. 8: Changing Table Contents Ch. 9: Database Security Ch. 10: Creating Database Tables, Indexes, Views, and Sequences Ch 11: Introducing PL/SQL Programming Ch. 12: Database Objects Ch. 13: Collections Ch. 14: Large Objects Ch 15: Native XML Support Ch. 16: Tuning Appendix A Oracle Data Types
