Building Intelligent Databases with Oracle PL/SQL (Bk/CD) (2nd Edition) - Softcover

Owens, Kevin T.

Softcover

ISBN 10: 0137943148 ISBN 13: 9780137943142

Publisher: Prentice Hall Ptr, 1997

Synopsis

Introduces the programming techniques and software engineering methods needed to build powerful, reusable enterprise software components. Coverage includes the fundamentals of PL/SQL; rules-based development; data types and composite structures; important types of database triggers and packages; how to combine and partition software; Oracle interprocess communication, error handling, exceptions, embedded SQL, SQL Plus scriptwriting; and advanced features such as stored procedures. Annotation c. by Book News, Inc., Portland, Or.

About this title

About the Author

KEVIN T. OWEN is an Oracle database consultant based in the Washington, DC area.

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.

Edition details

• Publisher: Prentice Hall Ptr
• Publication date: 1997
• Language: English
• ISBN 10: 0137943148
• ISBN 13: 9780137943142
• Binding: Paperback
• Edition number: 2
• Number of pages: 544