Oracle Server Manager User's Guide

The Triggers Folder

When you click the Triggers folder tab, the Triggers folder opens and the Trigger object list appears. The Trigger object list contains information about triggers defined on tables in the database.

A trigger is PL/SQL code that is implicitly executed when inserting, updating, or deleting data in a table. For information about triggers, see the Oracle7 Server Concepts and the Oracle7 Server Application Developer's Guide.

The following figure illustrates the Trigger object list.

Figure 7 - 2. Trigger Object List

Trigger Object List

The columns of the Trigger object list are described below:

Trigger Trigger owner and trigger name.
Table Owner and name of table on which the trigger is defined.
Type When the trigger fires: Before/After Statement or Before/After Each Row.
Event Type of statements that fire the trigger: Insert, Update, and/or Delete.
Status Status of the trigger: Enabled or Disabled.
When Condition that must be true for the trigger to fire (only applies to row triggers).

Trigger	Trigger owner and trigger name.
Table	Owner and name of table on which the trigger is defined.
Type	When the trigger fires: Before/After Statement or Before/After Each Row.
Event	Type of statements that fire the trigger: Insert, Update, and/or Delete.
Status	Status of the trigger: Enabled or Disabled.
When	Condition that must be true for the trigger to fire (only applies to row triggers).