Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series) [Paperback]

Kevin Owens (Author)

Book Description

ISBN-10: 0130850330 | ISBN-13: 978-0130850331 | Publication Date: December 5, 2003 | Edition: 3

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.

Editorial Reviews

From the Back Cover

• Complete tutorial for database developers!
• Thorough coverage of PL/SQL
• Practical "cookbook" techniques

Effectively create and manage complex databases with Oracle! Systems and database expert Kevin Owens explores PL/SQL, Oracle's answer to the Structured Query Language (SQL), and teaches you what you need to know to build robust and complex databases for your business.

Using easy-to-follow instructions and examples, this book presents techniques to take advantage of Oracle features such as triggers and stored procedures-features that allow your databases to incorporate business rules which are easy to manage and modify as the business evolves. Topics covered include:

• Viewing constraints in the data dictionary
• Complex rule enforcement
• PL/SQL program units and language features
• Data types and composite structure
• Error handling and exceptions
• Inter-process communications
• Declarative constraints, including primary key, unique, foreign key, check, and much more

Programming Oracle Triggers and Stored Procedures, Third Edition, is an invaluable resource for database developers, designers, and project leaders looking to build and maintain truly intelligent, complex databases

About the Author

KEVIN OWENS is the Oracle database administrator at the U.S. Department of the Treasury in Washington, DC.

See all Editorial Reviews

Product Details

• Paperback: 448 pages
• Publisher: Prentice Hall PTR; 3 edition (December 5, 2003)
• Language: English
• ISBN-10: 0130850330
• ISBN-13: 978-0130850331
• Product Dimensions: 9.2 x 7 x 1.2 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #2,299,065 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

5.0 out of 5 stars A great book . Very helpful PL/SQL, March 12, 2004

By A Customer

This review is from: Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series) (Paperback)

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.

1 of 1 people found the following review helpful:

4.0 out of 5 stars Excellent for the beginner!, March 8, 2005

By 

Alisa Polk - See all my reviews
(REAL NAME)   

This review is from: Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series) (Paperback)

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.