Building Intelligent Databases With Oracle Pl/Sql, Triggers, and Stored Procedures (Oracle Series) [Paperback]

Kevin T. Owens (Author), Kevin T. Owens (Author)

Book Description

Series: Oracle Series | Publication Date: October 1995

This text shows how to develop business applications, such as payroll or accounting software, using Oracle's version of SQL (Structured Query Language), triggers and stored procedures. It supports version 7.1 and illustrates through examples how to create and optimize applications using Oracle Triggers and stored procedure language. The accompanying disk has the source code samples found in the book.

Editorial Reviews

From the Publisher

This book shows how to develop commercial applications with Oracle, with a special emphasis on triggers and stored procedures. It covers declarative versus procedural methods of ensuring database integrity, strategies for integrating procedural methods with existing declarative methods.

From the Back Cover

The end-to-end resource for anyone who builds business rules-based Oracle database applications.

* Thorough coverage of PL/SQL, Oracle's version of SQL.
* Practical, "cookbook" techniques for using triggers, stored procedures, and other advanced Oracle features. Comprehensive troubleshooting and debugging techniques.
* CD-ROM includes the complete source code library from the book. Data types, composite structures, error handling, exceptions, and more.
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.

KEVIN T. OWEN is an Oracle database consultant based in the Washington, DC area. --This text refers to an out of print or unavailable edition of this title.

See all Editorial Reviews

Product Details

• Paperback: 370 pages
• Publisher: Prentice Hall (October 1995)
• Language: English
• ISBN-10: 0134436318
• ISBN-13: 978-0134436319
• Product Dimensions: 9.2 x 7 x 1.6 inches
• Shipping Weight: 1.6 pounds
• Average Customer Review: 3.4 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #3,650,469 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

9 of 9 people found the following review helpful:

4.0 out of 5 stars Excellent for serious developers, September 13, 1999

By A Customer

This review is from: Building Intelligent Databases with Oracle PL/SQL (Bk/CD) (2nd Edition) (Paperback)

A book like this is essential for real world projects. The author knows exactly what he is talking about and it is easy to tell he has been a developer because he addresses the issues that usually come up during the development phase of a project. Also, the examples illustrate the concepts very clearly and it hardly matters whether you are using UNIX or NT.

This book is way ahead of the other Oracle books I have seen. The reason I didn't give 5 stars is because this book doesn't cover the new Oracle8 features.

9 of 10 people found the following review helpful:

3.0 out of 5 stars A good book but there are too many errors, November 4, 1999

By A Customer

This review is from: Building Intelligent Databases with Oracle PL/SQL (Bk/CD) (2nd Edition) (Paperback)

I think this is a good book because it contains an introduction to the most important features of relational database and then it treat all aspects of PL/SQL, but I would like to know immediately how to debug Oracle PL/SQL programs without reading 210 pages. Next to that I found many type errors in the book.

6 of 6 people found the following review helpful:

4.0 out of 5 stars Excellent reference (For procedures, functions, triggers), July 28, 1999

By A Customer

This review is from: Building Intelligent Databases with Oracle PL/SQL (Bk/CD) (2nd Edition) (Paperback)

This is one of a number of publications I acquired when tasked with converting an existing Sybase SQL Server 11 system to Oracle. The current system relied heavily on stored procedures\functions with a fair amount of triggers. The fact that this book was laid out as well as it is made my job alot easier.