1. Introduction and Terminology -- 2. Declarative Constraints -- 3. Analyzing Constraints Through The Data Dictionary -- 4. Overview of Stored Procedures -- 5. The Development Environment -- 6. Data Types and Composite Structures -- 7. Constructing PL/SQL Subprograms -- 8. Exceptions and Error Handling -- 9. Packages -- 10. Stored Procedure Testing -- 11. Triggers -- 12. A Trigger Methodology (Part 1) -- 13. Mutating Table -- 14. A Trigger Methodology (Part 2).

Oracle 7 has become significantly more sophisticated in its ability to support complex formal rules. Development features of Oracle 7 and later releases support type definitions, declarative and procedural constraint checking, interprocess communication, dynamic SQL, user-defined functions, and program constructs that support modern software engineering concepts. Learn to build complex rules for local and distributed environments with these features. Building Intelligent Databases with Oracle PL/SQL, Triggers, and Stored Procedure Processing focuses on how to develop procedural constraints through triggers and stored procedures. By integrating them with other enforcement methods, you will be able to achieve a maintainable, dynamic system, capable of evolving with your organization's needs. In addition to programming and code examples, topics include testing, configuration management, and version control. Code examples from each chapter are drawn from a single data model that forms a constant frame of reference throughout all chapters. Detailed walkthroughs are given for developing complex triggers, classifying triggers by complexity levels, and integrating them with declarative constraints. You'll use the code examples to construct your own test environment, drawing from the compilable trigger and stored procedure code provided. The conclusion contains a case study that enforces a series of complex rules. This includes all trigger and stored procedure code necessary to simulate the case study.