Building Intelligent Databases with Oracle PL/SQL (Bk/CD)
Kevin Owens(Author)
Prentice Hall (Publisher)
2nd Edition
Published on 24. December 1997
Book
Mixed media product
560 pages
978-0-13-794314-2 (ISBN)
Article exhausted; check for reprint
Description
Advanced Oracle features such as triggers and stored procedures make it possible to build databases that incorporate business rules - allowing companies to reengineer processes more quickly and effectively than ever. This is the "bible" for anyone designing complex Oracle databases that incorporate business rules. It presents a simple methodology which yields a highly-maintainable repository of triggers and stored procedures which are easy to manage and modify as the business changes. Topics covered include: declarative constraints; analyzing constraints through the data dictionary; PL/SQL program units; embedded SQL; data types and composite structures; error handling and exceptions; and interprocess communication. If you are an Oracle database developer working with Business Rules - or planning to - you'll find this book invaluable.
More details
Edition
2nd edition
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Width: 236 mm
Thickness: 41 mm
Weight
1108 gr
ISBN-13
978-0-13-794314-2 (9780137943142)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions

Book
12/2003
3rd Edition
Prentice Hall
€49.51
Article is exhausted; no reprint
Previous edition
Book
01/1996
Prentice Hall
€33.41
Article exhausted; check for reprint
Person
KEVIN T. OWEN is an Oracle database consultant based in the Washington, DC area.
Content
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.