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.
"synopsis" may belong to another edition of this title.
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.
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.
"About this title" may belong to another edition of this title.
FREE shipping within U.S.A.
Destination, rates & speedsSeller: SecondSale, Montgomery, IL, U.S.A.
Condition: Very Good. Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00082506867
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 2.4. Seller Inventory # G0137943148I3N00
Quantity: 1 available
Seller: Wonder Book, Frederick, MD, U.S.A.
Condition: Very Good. Very Good condition. 2nd edition. Disk included. A copy that may have a few cosmetic defects. May also contain light spine creasing or a few markings such as an owner's name, short gifter's inscription or light stamp. Seller Inventory # K02K-00909
Quantity: 1 available
Seller: Romtrade Corp., STERLING HEIGHTS, MI, U.S.A.
Condition: New. This is a Brand-new US Edition. This Item may be shipped from US or any other country as we have multiple locations worldwide. Seller Inventory # ABTA-341030
Quantity: 1 available
Seller: Basi6 International, Irving, TX, U.S.A.
Condition: Brand New. New. US edition. Expediting shipping for all USA and Europe orders excluding PO Box. Excellent Customer Service. Seller Inventory # ABEJUNE24-334400
Quantity: 1 available
Seller: The Book Spot, Sioux Falls, MN, U.S.A.
Paperback. Condition: New. Seller Inventory # Abebooks31967
Quantity: 1 available
Seller: Books Puddle, New York, NY, U.S.A.
Condition: Used. pp. 544 2nd Edition. Seller Inventory # 263159065
Quantity: 1 available
Seller: Majestic Books, Hounslow, United Kingdom
Condition: Used. pp. 544. Seller Inventory # 4688838
Quantity: 1 available
Seller: Biblios, Frankfurt am main, HESSE, Germany
Condition: Used. pp. 544. Seller Inventory # 183159059
Quantity: 1 available
Seller: dsmbooks, Liverpool, United Kingdom
Paperback. Condition: Like New. Like New. book. Seller Inventory # D7F7-3-M-0137943148-6
Quantity: 1 available