Average Reviews:
(More customer reviews)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.
Click Here to see more reviews about: Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)
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.
