3rd Edition
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 unit...