Building Intelligent Databases with Oracle PL/SQL, Triggers, and Stored Procedure

by Kevin T. Owens

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... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0134436318
• ISBN13: 9780134436319
• Release Date: January 1995
• Publisher: Prentice Hall PTR
• Length: 370 Pages
• Weight: 1.56 lbs.
• Dimensions: 1.1" x 7.0" x 9.2"

Customer Reviews

general discussion, good source of PL/SQL knowledge

Stored procedures and especially triggers usually cooperate with other system components, they are sensitive to intricate system configuration changes. True appeciation of the power of Oracle environment comes from comparison of PL/SQL collections and APIs provided by built-in packages (like DMBS_PIPE) - with host operating system IPCs.Now we can see the challenge of BUILDING INTELLIGENT DATABASES: the book starts from PL/SQL basics and proceeds to exception handling, interprocesscommunication and database integrity enforcement.In ch.7 we find discussion of basic PL/SQL constructs, datatypes and data structures (including index by tables, but without collections that were added later) are covered by ch.9. Exceptions (necessary to deal with built-in packages) are described in ch.10.Material of chapters 14-17(trigger methodolgy and procedural constraints) is, in fact, software life cycle discussion: development starts from finding out what concrete objects are to be encapsulated and in what way, proprietary integrity constraints are determined. Then certain PL/SQL code is developed and tested, results are re-assessed, more code is developed, etc. - all on concrete code examples. Discussion of Mutable Table situation is very helpful.Basically, BUILDING INTELLIGENT DATABASES shows two things: how one actually builds PL/SQL applications and how general terminology can be used in the process.An important practical suggestion here is to develop triggers as wrappers for packages which is very helpful - from C++/Java point of view.Ch.19 discusses basic package testing using DBMS_OUTPUT. Package methods are usually called from other components, for example, Pro*C/C++ applications. So it is useful to simulate actual calls by special PL/SQL testing wrappers. Then actual component cooperation is tested.Sample code from the book is easy to read, I'd take it more as illustration than working demo or systemconfiguration benchmark.

Good introduction, but beware of the examples!

This appears to be a good introduction to useful PL/Sql coding and techniques. Everything in this book is in the two Official Oracle Press PL/Sql Programming books but more time is spent explaining both the how and the why and making suggestions. But beware of the example code: some of them have typo errors and some won't run even with the typo's corrected. I sometimes had to debug and correct the code before it would run. This is not unique to this book, but it is not fun debugging code that should already run. Still, I found the book very useful.

Excellent for serious developers

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.

Excellent reference (For procedures, functions, triggers)

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.

Excellent, Good value for money!

I AM SURE GLAD I BOUGHT THIS BOO, THE AUTHOR DID A GREAT JOB- TAKING THE READER FROM THE BASICS TO ADVANCED PL/SQL TOPICS.THIS BOOK HAD IN IT WHAT MANY BOOKS ON THE MARKET HAD MISSING AND THE UNIQUNESS IS THE SIMPLICITY IN IT'S LANGUAGE. Y GO ON GET A COPY, YOU WON'T REGRET IT!!!