ALL_TRIGGERS describes owned by the current user and triggers on tables owned by 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 all 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: BEFORE STATEMENT, BEFORE EACH ROW, BEFORE EVENT, AFTER STATEMENT, AFTER EACH ROW, and AFTER EVENT |
|
TRIGGERING_EVENT |
VARCHAR2(227) |
The DML, DDL, or database event that fires the trigger. For a listing of triggering events, see the CREATE TRIGGER statement in Oracle Database SQL Reference. |
|
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, VIEW, SCHEMA, or DATABASE |
|
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, this columns indicates the table/view name on which the trigger is defined |
|
COLUMN_NAME |
VARCHAR2(4000) |
Name of the nested table column (if 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 (CALL or PL/SQL) |
|
TRIGGER_BODY |
LONG |
Statements executed by the trigger when it fires |