Programming Oracle Triggers And Stored Procedures, Third Edition

Advanced Oracle features such as triggers and stored procedures make itpossible to build databases that incorporate business rules - allowing companiesto reengineer processes more quickly and effectively than ever. This is the`bible` for anyone designing complex Oracle databases that incorporatebusiness rules, and it is fully compliant with Oracle 10g. The book presents asimple methodology which yields a highly-maintainable repository of triggersand stored procedures which are easy to manage and modify as the businesschanges. Topics covered include: declarative constraints; analyzing constraintsthrough the data dictionary; PL/SQL program units; embedded SQL; datatypes and composite structures; error handling and exceptions; andinterprocess 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 providescritical information to the end user when triggered.

User review
Excellent for the beginner!
This book provides an excellent starting place for the beginning programmer or DBA. There is a ton of information on relational databases & how they relate to Oracle. If you haven't been using Oracle for long then this is an excellent book to have! If you are already experienced in Oracle and looking for a reference book - or an advanced book - this isn't it.

User review
A great book . Very helpful PL/SQL
This is an excellent beginner's book for programmers. It begins with an emphasises on the basics of creating tables with declarative constraints. Following this is an easy-to-understand graphical and written description of how to use database triggers to enhance the integrity of the database; then several chapters on PL/SQL. What I liked most about this book is the plain and simple approach to some complex topics. I would recommed this book to any technical person who wants to learn Oracle quickly. I almost didn't buy it because the key word `PL/SQL` is not in the title but it certainly provides nice coverage of PL/SQL, not just the language syntax but an intuitive meaning of the package specification and body.