Oracle Database 10g SQL

0.0

Key Features The book content is being developed in concert with the Oracle development team to cover the next release of the database and Oracle?s compliance with the new SQL2003 specification. This book will take the reader from no knowledge of Oracle SQL to being a master?covering not only how to use SQL but also the details of the Oracle extensions to SQL. This book will cover the details on how to use SQL with an Oracle database. Coverage of SQL*Plus will also be provided. The examples in this book will feature the sample schemas available to everyone in the database. Any additional code will be made available for download. Tuning Oracle SQL and understanding the Oracle optimizer (not covered in the competing books) will also be covered. Introduces database programming with PL/SQL and Java About The Author Jason Price is a freelance consultant and former product manager at Oracle Corporation. He has contributed to many of Oracle's products and is an Oracle Certified Database Administrator and Application Developer. Table Of Contents Chapter 1: Introduction Chapter 2: Retrieving Information from Tables Chapter 3: Using Simple Functions Chapter 4: Storing and Processing Dates and Times Chapter 5: Using SQL *Plus Chapter 6: Subqueries Chapter 7: Advanced Select Functions Chapter 8: Changing Table Contents Chapter 9: Database Security Chapter 10: Creating Database Tables, Indexes, Views, and Sequences Chapter 11: Introducing PL/SQL Programming Chapter 12: Database Objects Chapter 13: Collections Chapter 14: Large Objects Chapter 15: Native XML Support Chapter 16: Tuning Appendix A Oracle Data Types