Building intelligent databases with Oracle PL/SQL, triggers, and stored procedures / Kevin T. Owens.
Material type:
TextPublication details: Upper Saddle River, NJ : Prentice Hall PTR, c1998.Edition: 2nd edDescription: xvi, 544 p. : ill. ; 24 cm. +ISBN: - 0137943148
- Oracle PL/SQL [Spine title]
- QA76.9.D3 O93 1998
| Item type | Current library | Call number | Copy number | Status | Barcode | |
|---|---|---|---|---|---|---|
| Books | Library First Floor | QA76.9.D3 O93 1998 (Browse shelf(Opens below)) | 1 | Available | 3412 | |
| Books | Library First Floor | QA76.9.D3 O93 1998 (Browse shelf(Opens below)) | 2 | Available | 237 |
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.
There are no comments on this title.