Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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

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