Main Page

	Table of Contents

 

Programming Oracle Triggers and Stored Procedures, Third Edition
By Kevin Owens
Publisher	: Prentice Hall PTR
Pub Date	: December 05, 2003
ISBN	: 0-13-085033-0
Pages	: 448

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.