Static Data Dictionary Views, 94 of 452

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 Oracle8i 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 or 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

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 Oracle8i 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` or `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