Triggers Notes

·     Overview of Triggers

·     Reasons to Use Triggers

·     DML Triggers

·     Conditional Predicates for Detecting Triggering DML Statement

·     INSTEAD OF DML Triggers

·     Compound DML Triggers

·     Compound DML Trigger Structure

·     Compound DML Trigger Restrictions

·     Performance Benefit of Compound DML Triggers

·     Using Compound DML Triggers with Bulk Insertion

·     Using Compound DML Triggers to Avoid Mutating-Table Error

·     Triggers for Ensuring Referential Integrity

·     Foreign Key Trigger for Child Table

·     UPDATE and DELETE RESTRICT Trigger for Parent Table

·     UPDATE and DELETE SET NULL Trigger for Parent Table

·     DELETE CASCADE Trigger for Parent Table

·     UPDATE CASCADE Trigger for Parent Table

·     Triggers for Complex Constraint Checking

·     Triggers for Complex Security Authorizations

·     Triggers for Transparent Event Logging

·     Triggers for Deriving Column Values

·     Triggers for Building Complex Updatable Views

·      Triggers for Fine-Grained Access Control

·      Correlation Names and Pseudorecords

·      OBJECT_VALUE Pseudocolumn

·      System Triggers

·     SCHEMA Triggers

·     DATABASE Triggers

·     INSTEAD OF CREATE Triggers

·     Subprograms Invoked by Triggers

·     Trigger Compilation, Invalidation, and Recompilation

·     Exception Handling in Triggers

·     Trigger Design Guidelines

·     Trigger Restrictions

·     Trigger Size Restriction

·     Trigger LONG and LONG RAW Data Type Restrictions

·     Mutating-Table Restriction

·     Order in Which Triggers Fire

·     Trigger Enabling and Disabling

·     Trigger Changing and Debugging

·     Triggers and Oracle Database Data Transfer Utilities

·     Triggers for Publishing Events

·     Event Attribute Functions

·     Event Attribute Functions for Database Event Triggers

·     Event Attribute Functions for Client Event Triggers

·     Views for Information About Triggers