ALL_TRIGGERS

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.

Related Views

• 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)	NOT NULL	Owner of the trigger
  TRIGGER_NAME	VARCHAR2(30)	NOT NULL	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(216)		The DML, DDL, or database event that fires the trigger. For a listing of triggering events, see the CREATE TRIGGER statement in Oracle9i SQL Reference.
  TABLE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the table on which the trigger is defined
  BASE_OBJECT_TYPE	VARCHAR2(16)		The 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(30)		Name of the nested table column (if nested table trigger), else null
  REFERENCING_NAMES	VARCHAR2(87)		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)		Whether the trigger is enabled (ENABLED|DISABLED)
  DESCRIPTION	VARCHAR2(4000)		Trigger description; useful for re-creating a trigger creation statement
  ACTION_TYPE	VARCHAR2(11)		The action type of the trigger body (CALL or PL/SQL)
  TRIGGER_BODY	LONG		Statement(s) executed by the trigger when it fires