|
Oracle Database 11g SQL: Master SQL and PL/SQL in the Oracle Environment
Master SQL in the Oracle environment
Covering the latest SQL enhancements in the new database release, this Oracle Press guide offers complete coverage of this standard database programming language.Through a wealth of practical examples, code samples, and programming tips, you will learn to master SQL as well as the Oracle extensions to
SQL. No prior knowledge of the Oracle database, SQL, or PL/SQL is assumed.
CONTENTS:
Chapter 1. Introduction
Chapter 2. Retrieving Information from Tables
Chapter 3. Using SQL *Plus
Chapter 4. Using Simple Functions
Chapter 5. Storing and Processing Dates and Times
Chapter 6. Subqueries
Chapter 7. Advanced Queries
Chapter 8. Changing Table Contents
Chapter 9. Users, Privileges, and Roles
Chapter 10. Creating Tables, Sequences, Indexes, and Views
Chapter 11. Introducing PL/SQL Programming
Chapter 12. Database Objects
Chapter 13. Collections
Chapter 14. Large Objects
Chapter 15. Running SQL Using Java
Chapter 16. SQL Tuning
Chapter 17. XML and the Oracle Database
Appendix: Oracle Data Types
Index
|
