Includes index.

A quick tour of SQL Plus; declarative constraints; analyzing constraints through the data dictionary; PL/SQL program units; the development environment; syntax and constructs; embedded SQL; data types and composite structures; error handling and exceptions; interprocess communication; dynamic SQL; triggers; triggers as procedural constraints; a trigger methodology; mutating tables; a trigger methodology (part 2); case study; stored procedural testing.

This work offers a "cookbook" approach to implementing complex business rules with triggers and stored procedures. It provides methods for debugging and trouble-shooting, and explains how to use the advanced features of Oracle to implement complex designs in a client/server architecture.