ALL_TRIGGER_ORDERING describes the triggers accessible to the current user that have FOLLOWS or PRECEDES ordering.
DBA_TRIGGER_ORDERING describes all triggers in the database that have FOLLOWS or PRECEDES ordering.
USER_TRIGGER_ORDERING describes the triggers owned by the current user that have FOLLOWS or PRECEDES ordering. This view does not display the TRIGGER_OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
TRIGGER_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the trigger |
TRIGGER_NAME |
VARCHAR2(30) |
Name of the trigger | |
REFERENCED_TRIGGER_OWNER |
VARCHAR2(30) |
Owner of the referenced trigger | |
REFERENCED_TRIGGER_NAME |
VARCHAR2(30) |
Name of the referenced trigger | |
ORDERING_TYPE |
VARCHAR2(8) |
Type of the ordering between the trigger and the referenced trigger:
|