Chapter Six. Row Trigger Mechanics


6.1 INTRODUCTION

6.2 BEFORE VERSUS AFTER

6.3 INSERT ROW TRIGGER SYNTAX

6.4 TRIGGER BODY

6.5 EXAMPLE ROW TRIGGERS

6.6 A TABLE WITH ORACLE CONSTRAINTS AND BUSINESS RULES

6.6.1 The Environment

6.6.2 The Procedural Constraints to Enforce

6.6.3 Before versus After

6.6.4 Using Packages for Procedural Constraints

6.6.5 Managing Error Codes and Messages

6.6.6 Trigger Architecture

This chapter covers the mechanics of row triggers. Most examples are given with INSERT triggers. Row triggers can fire from INSERT, UPDATE, and DELETE statements. The objective is to cover the mechanics of row triggers first, and then treat differences among insert-row, update-row, and delete-row triggers.



Programming Oracle Triggers and Stored Procedures
Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)
ISBN: 0130850330
EAN: 2147483647
Year: 2003
Pages: 111
Authors: Kevin Owens

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net