ALL_TRIGGERS
describes the triggers on tables accessible to the current user. If the user has the CREATE ANY TRIGGER
privilege, then this view describes all triggers in the database.
DBA_TRIGGERS
describes all triggers in the database.
USER_TRIGGERS
describes the triggers owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the trigger | |
TRIGGER_NAME |
VARCHAR2(30) |
Name of the trigger | |
TRIGGER_TYPE |
VARCHAR2(16) |
When the trigger fires:
|
|
TRIGGERING_EVENT |
VARCHAR2(227) |
DML, DDL, or database event that fires the trigger
See Also: The |
|
TABLE_OWNER |
VARCHAR2(30) |
Owner of the table on which the trigger is defined | |
BASE_OBJECT_TYPE |
VARCHAR2(16) |
Base object on which the trigger is defined:
|
|
TABLE_NAME |
VARCHAR2(30) |
If the base object type of the trigger is SCHEMA or DATABASE , then this column is NULL; if the base object type of the trigger is TABLE or VIEW , then this column indicates the table or view name on which the trigger is defined |
|
COLUMN_NAME |
VARCHAR2(4000) |
Name of the nested table column (if a nested table trigger), else NULL | |
REFERENCING_NAMES |
VARCHAR2(128) |
Names used for referencing OLD and NEW column values from within the trigger |
|
WHEN_CLAUSE |
VARCHAR2(4000) |
Must evaluate to TRUE for TRIGGER_BODY to execute |
|
STATUS |
VARCHAR2(8) |
Indicates whether the trigger is enabled (ENABLED ) or disabled (DISABLED ) |
|
DESCRIPTION |
VARCHAR2(4000) |
Trigger description; useful for re-creating a trigger creation statement | |
ACTION_TYPE |
VARCHAR2(11) |
Action type of the trigger body:
|
|
TRIGGER_BODY |
LONG |
Statements executed by the trigger when it fires |
See Also: