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

Author: (USA) Owens, K. (Author), Yangouyu (Translator)
Publisher:
Publish Date: 2004-10-01
Features: Effectively Create and Manage Large Databases with Oracle! Kevin Owens, a database expert and Oracle database administrator at the U.S. Treasury Computer Center, will guide you through PL/SQL—Oracle's structured query language (SQL)—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 integrate 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
· Interprocess 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, an Oracle database administrator at the U.S. Treasury Computer Center, will guide you through PL/SQL—Oracle's structured query language (SQL)—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 integrate 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
· Interprocess 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.