Oracle8i Reference Release 2 (8.1.6) Part Number A76961-01 |
|
Static Data Dictionary Views, 94 of 452
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.
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 of the trigger |
|
|
|
Name of the trigger |
|
|
|
When the trigger fires: |
|
|
|
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. |
|
|
|
Owner of the table on which the trigger is defined |
|
|
|
The base object on which the trigger is defined: |
|
|
|
If the base object type of the trigger is |
|
|
|
Name of the nested table column (if nested table trigger), else null |
|
|
|
Names used for referencing OLD and NEW column values from within the trigger |
|
|
|
Must evaluate to |
|
|
|
Whether the trigger is enabled: |
|
|
|
Trigger description. Useful for re-creating a trigger creation statement. |
|
|
|
The action type of the trigger body: |
|
|
|
Statement(s) executed by the trigger when it fires |
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|