ALL_TRIGGERS

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.

Related Views

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	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` `AFTER STATEMENT` `AFTER EACH ROW` `INSTEAD OF` `COMPOUND`
`TRIGGERING_EVENT`	`VARCHAR2(227)`	DML, DDL, or database event that fires the trigger See Also: The `CREATE TRIGGER` statement in Oracle Database SQL Language Reference for a listing of triggering events
`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` `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`, 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: `CALL` `PL/SQL`
`TRIGGER_BODY`	`LONG`	Statements executed by the trigger when it fires