Creating Triggers

To create triggers, use either the SQL Developer tool Create Trigger or the DDL statement CREATE TRIGGER. This topic shows how to use both of these ways to create triggers.

By default, a trigger is created in the enabled state. To create a trigger in disabled state, use the CREATE TRIGGER statement with the DISABLE clause.

This section contains:

• About OLD and NEW Pseudorecords

• Tutorial: Creating a Trigger that Logs Table Changes

• Tutorial: Creating a Trigger that Generates a Primary Key for a Row Before It Is Inserted

• Creating an INSTEAD OF Trigger

• Creating Triggers that Log LOGON and LOGOFF Events