home - keyword index

Table: ALL_TRIGGERS

Triggers accessible to the current user

Column Name Description
ACTION_TYPE
BASE_OBJECT_TYPE
COLUMN_NAME The name of the column on which the trigger is defined over
DESCRIPTION Trigger description, useful for re-creating trigger creation statement
OWNER Owner of the trigger
REFERENCING_NAMES Names used for referencing to OLD and NEW values within the trigger
STATUS If DISABLED then trigger will not fire
TABLE_NAME Name of the table that this trigger is associated with
TABLE_OWNER Owner of the table that this trigger is associated with
TRIGGERING_EVENT Statement that will fire the trigger - INSERT, UPDATE and/or DELETE
TRIGGER_BODY Action taken by this trigger when it fires
TRIGGER_NAME Name of the trigger
TRIGGER_TYPE When the trigger fires - BEFORE/AFTER and STATEMENT/ROW
WHEN_CLAUSE WHEN clause must evaluate to true in order for triggering body to execute

home - keyword index

Comment on this page: