Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You?ll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to OLAP and from data warehousing to business intelligence. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management. The companion CD-ROM includes all the source code for the examples in the book.
Table of Contents:
PART I: Introductory Concepts
1. Introduction to PL/SQL
2. PL/SQL by Dissection
3. New Features in PL/SQL
PART II: Techniques for PL/SQL Programming
Chapter 4: Data Structure Management in PL/SQL
5. Error Management in PL/SQL
6.Data Management in PL/SQL
7. Application Management in PL/SQL
8. Transaction Management in PL/SQL
PART III: Applying PL/SQL in the real world
9. Application Development Frameworks Using PL/SQL
10. Applying PL/SQL in 3GL and Web Environment
11. PL/SQL Tuning and Debugging
12. PL/SQL Coding Standards