The following data dictionary views contain information about triggers:
- USER_TRIGGERS
- ALL_TRIGGERS
- DBA_TRIGGERS
Columns indicate the following:
- The new column, BASE_OBJECT_TYPE, specifies whether the trigger is based on DATABASE, SCHEMA, table, or view.
- The old column, TABLE_NAME, is null if the base object is not table or view.
- The column ACTION_TYPE specifies whether the trigger is a call-type trigger or a PL/SQL trigger.
- The column TRIGGER_TYPE includes two additional values: BEFORE EVENT and AFTER EVENT, applicable only to system events.
- The column TRIGGERING_EVENT includes all system and DML events.