Programming Oracle® Triggers and Stored Procedures, Third Edition

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.