Oracle Triggers and Stored Procedure Programming

Oracle Triggers and Stored Procedure Programming

by Kevin T. Owens
     
 

View All Available Formats & Editions

Oracle 7 has become significantly more sophisticated in its ability to support complex formal rules. Development features of Oracle 7 and later releases support type definitions, declarative and procedural constraint checking, interprocess communication, dynamic SQL, user-defined functions, and program constructs that support modern software engineering concepts.… See more details below

Overview

Oracle 7 has become significantly more sophisticated in its ability to support complex formal rules. Development features of Oracle 7 and later releases support type definitions, declarative and procedural constraint checking, interprocess communication, dynamic SQL, user-defined functions, and program constructs that support modern software engineering concepts. Learn to build complex rules for local and distributed environments with these features. Building Intelligent Databases with Oracle PL/SQL, Triggers, and Stored Procedure Processing focuses on how to develop procedural constraints through triggers and stored procedures. By integrating them with other enforcement methods, you will be able to achieve a maintainable, dynamic system, capable of evolving with your organization's needs. In addition to programming and code examples, topics include testing, configuration management, and version control. Code examples from each chapter are drawn from a single data model that forms a constant frame of reference throughout all chapters. Detailed walkthroughs are given for developing complex triggers, classifying triggers by complexity levels, and integrating them with declarative constraints. You'll use the code examples to construct your own test environment, drawing from the compilable trigger and stored procedure code provided. The conclusion contains a case study that enforces a series of complex rules. This includes all trigger and stored procedure code necessary to simulate the case study.

Read More

Editorial Reviews

Booknews
Focuses on how to develop procedural constraints through triggers and stored procedures, integrating them with other enforcement methods to achieve a maintainable system which is capable of evolving as needed. Topics include testing, configuration management, and version control, with programming and code examples. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Product Details

ISBN-13:
9780134436319
Publisher:
Prentice Hall Professional Technical Reference
Publication date:
12/28/1995
Edition description:
Older Edition
Pages:
384
Product dimensions:
7.05(w) x 9.23(h) x 1.15(d)

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >