Programming Oracle Triggers and Stored Procedures - Couverture souple

Owens, Kevin

Couverture souple

ISBN 10 : 0130850330 ISBN 13 : 9780130850331

Editeur : Prentice Hall, 2003

Synopsis

Advanced Oracle features such as triggers and stored procedures make itpossible to build databases that incorporate business rules - allowing companiesto reengineer processes more quickly and effectively than ever. This is the"bible" for anyone designing complex Oracle databases that incorporatebusiness rules, and it is fully compliant with Oracle 10g. The book presents asimple methodology which yields a highly-maintainable repository of triggersand stored procedures which are easy to manage and modify as the businesschanges. Topics covered include: declarative constraints; analyzing constraintsthrough the data dictionary; PL/SQL program units; embedded SQL; datatypes and composite structures; error handling and exceptions; andinterprocess communication.A trigger is a condition, which if true, causes a stored procedure to execute.Stored procedures are SQL code embedded in the database that providescritical information to the end user when triggered.

A propos du livre

À propos de l?auteur

KEVIN OWENS is the Oracle database administrator at the U.S. Department of the Treasury in Washington, DC.

Détails de l'édition

• Éditeur: Prentice Hall
• Date d'édition: 2003
• Langue: anglais
• ISBN 10: 0130850330
• ISBN 13: 9780130850331
• Reliure: Broché
• Numéro d'édition: 3
• Nombre de pages: 448
• Coordonnées du fabricant: non disponible
• Personne responsable: non disponible