Advanced Programming of Oracle Triggers and Stored Procedures (3rd Edition)

Author: Kevin Owens
Publisher:
Publish Date: 2004-10-01
Features: Effectively Create and Manage Large Databases with Oracle! Database expert Kevin Owens is an Oracle database administrator at the U.S. Department of the Treasury's Computer Center. He will explore PL/SQL—Oracle's structured query language (SQL)—with you and teach you how to solve your business problems by building robust, large-scale databases. The book is written in an easy-to-understand language and includes numerous code examples. It provides detailed explanations of many techniques to leverage Oracle's features, such as triggers and stored procedures. These features enable the database to incorporate business rules and allow for the management and modification of rules as business evolves. The topics covered in this book include:
· Constraints in the data dictionary
· Implementing complex rules
· PL/SQL program units and language features
· Data types and composite structures
· Error handling and exceptions
· Inter-process communication
· Declarative constraints, including primary key constraints, unique constraints, foreign key constraints, and check constraints, etc.
This book is an invaluable resource for developers, designers, and project managers who wish to build and maintain intelligent, large-scale databases. Effectively Create and Manage Large Databases with Oracle! Database expert Kevin Owens is an Oracle database administrator at the U.S. Department of the Treasury's Computer Center. He will explore PL/SQL—Oracle's structured query language (SQL)—with you and teach you how to solve your business problems by building robust, large-scale databases. The book is written in an easy-to-understand language and includes numerous code examples. It provides detailed explanations of many techniques to leverage Oracle's features, such as triggers and stored procedures. These features enable the database to incorporate business rules and allow for the management and modification of rules as business evolves. The topics covered in this book include:
· Constraints in the data dictionary
· Implementing complex rules
· PL/SQL program units and language features
· Data types and composite structures
· Error handling and exceptions
· Inter-process communication
· Declarative constraints, including primary key constraints, unique constraints, foreign key constraints, and check constraints, etc.
This book is an invaluable resource for developers, designers, and project managers who wish to build and maintain intelligent, large-scale databases.