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 |
