Programming Oracle Triggers & Stored Procedures

The authoritative guide for anyone designing complex Oracle databases that incorporate business rules.Build databases that allow your organization to reengineer processes more quickly and effectively than ever before! Practical 'cookbook' techniques for using triggers, stored procedures, and other advanced Oracle features Thorough coverage of PL/SQL, Oracle's version of SQLAdvanced Oracle features such as triggers and stored procedures make it possible to build databases that incorporate business rules - allowing companies to reengineer processes more quickly and effectively than ever. This is the 'bible' for anyone designing complex Oracle databases that incorporate business rules. The book presents a simple methodology which yields a highly-maintainable repository of triggers and stored procedures which are easy to manage and modify as the business changes. Topics covered include: declarative constraints; analyzing constraints through the data dictionary; PL/SQL program units; embedded SQL; data types and composite structures; error handling and exceptions; and interprocess communication. A trigger is a condition, which if true, causes a stored procedure to execute. Stored procedures are SQL code embedded in the database that provides critical information to the end user when triggered.