Building intelligent databases with Oracle PL/SQL, triggers, and stored procedures /
Owens, Kevin T.
Building intelligent databases with Oracle PL/SQL, triggers, and stored procedures / Oracle PL/SQL Kevin T. Owens. - 2nd ed. - Upper Saddle River, NJ : Prentice Hall PTR, c1998. - xvi, 544 p. : ill. ; 24 cm. +
Includes index.
A quick tour of SQL Plus; declarative constraints; analyzing constraints through the data dictionary; PL/SQL program units; the development environment; syntax and constructs; embedded SQL; data types and composite structures; error handling and exceptions; interprocess communication; dynamic SQL; triggers; triggers as procedural constraints; a trigger methodology; mutating tables; a trigger methodology (part 2); case study; stored procedural testing.
This work offers a "cookbook" approach to implementing complex business rules with triggers and stored procedures. It provides methods for debugging and trouble-shooting, and explains how to use the advanced features of Oracle to implement complex designs in a client/server architecture.
0137943148
Oracle (Computer file)
Relational databases.
PL/SQL (Computer program language)
QA76.9.D3 / O93 1998
Building intelligent databases with Oracle PL/SQL, triggers, and stored procedures / Oracle PL/SQL Kevin T. Owens. - 2nd ed. - Upper Saddle River, NJ : Prentice Hall PTR, c1998. - xvi, 544 p. : ill. ; 24 cm. +
Includes index.
A quick tour of SQL Plus; declarative constraints; analyzing constraints through the data dictionary; PL/SQL program units; the development environment; syntax and constructs; embedded SQL; data types and composite structures; error handling and exceptions; interprocess communication; dynamic SQL; triggers; triggers as procedural constraints; a trigger methodology; mutating tables; a trigger methodology (part 2); case study; stored procedural testing.
This work offers a "cookbook" approach to implementing complex business rules with triggers and stored procedures. It provides methods for debugging and trouble-shooting, and explains how to use the advanced features of Oracle to implement complex designs in a client/server architecture.
0137943148
Oracle (Computer file)
Relational databases.
PL/SQL (Computer program language)
QA76.9.D3 / O93 1998