Managing Triggers in the Database

Previous

Next

Triggers are another type of database object that you can manage with Object Browser. You can also create and update triggers with the SQL Commands page or SQL Editor page.

In addition, you can use SQL Command Line (SQL*Plus) to create and update triggers. For information about using SQL Command Line, see Using SQL Command Line.

• Creating a Trigger With the SQL Commands Page

• Creating a Trigger With the Object Browser Page

• Viewing a Trigger With Object Browser

• Creating a Trigger With the AFTER and FOR EACH ROW Option

• Creating a Trigger With the BEFORE Option and WHEN Clause

• Creating a Trigger With an Exception Handler

• Creating a Trigger That Fires Once For Each Update

• Creating LOGON and LOGOFF Triggers

• Modifying Triggers

• Dropping Triggers

• Disabling Triggers

• Enabling Triggers

• Compiling Triggers