4.144 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 theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the trigger |
|
|
|
Name of the trigger |
|
|
|
When the trigger fires:
|
|
|
|
DML, DDL, or database event that fires the trigger See Also: Oracle Database PL/SQL Language Reference for additional information about triggers and triggering events. |
|
|
|
Owner of the table on which the trigger is defined |
|
|
|
Base object on which the trigger is defined:
|
|
|
|
If the base object type of the trigger is |
|
|
|
Name of the nested table column (if a nested table trigger), else NULL |
|
|
|
Names used for referencing |
|
|
|
Must evaluate to |
|
|
|
Indicates whether the trigger is enabled ( |
|
|
|
Trigger description; useful for re-creating a trigger creation statement |
|
|
|
Action type of the trigger body:
|
|
|
|
Statements executed by the trigger when it fires |
|
|
|
Type of crossedition trigger:
|
|
|
|
Indicates whether the trigger has a |
|
|
|
Indicates whether the trigger has a |
|
|
|
Indicates whether the trigger has an |
|
|
|
Indicates whether the trigger has an |
|
|
|
Indicates whether the trigger has an |
|
|
|
Indicates whether the trigger will fire only for user processes making changes ( |
|
|
|
Indicates whether the trigger will only fire for a Replication Apply or SQL Apply process ( See Also: the |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY
procedure