Oracle Database 10g SQL

by Jason Price

Overview

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 10g, and free code will be available for download.

Product Details

ISBN-13:	9780071706704
Publisher:	McGraw Hill LLC
Publication date:	03/12/2004
Series:	Oracle Press
Sold by:	Barnes & Noble
Format:	eBook
Pages:	608
File size:	35 MB
Note:	This product may take a few minutes to download.

About the Author

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.

Table of Contents

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