You can ascertain lots of information about triggers by issuing queries against the following data dictionary views:
DBA_TRIGGERS
All triggers in the database
ALL_TRIGGERS
All triggers accessible to the current user
USER_TRIGGERS
All triggers owned by the current user
Table 18-4 summarizes the most useful (and common) columns in these views.
| Table 18-4. Useful columns in trigger views | |
| Name | Description |
| TRIGGER_NAME | The name of the trigger |
| TRIGGER_TYPE | The type of the trigger; you can specify: For DML triggers: BEFORE_STATEMENT, BEFORE EACH ROW, AFTER EACH ROW, or AFTER STATEMENT. For DDL triggers: BEFORE EVENT or AFTER EVENT. For INSTEAD OF triggers: INSTEAD OF. For AFTER_SUSPEND triggers: AFTER EVENT. |
| TRIGGERING EVENT | The event that causes the trigger to fire: For DML triggers: UPDATE, INSERT, or DELETE For DDL triggers: The DDL operation (see full list in the DDL trigger section of this chapter) For database event triggers: ERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN For INSTEAD OF triggers: INSERT, UPDATE, or DELETE For AFTER SUSPEND triggers: SUSPEND |
| TABLE_OWNER | This column contains different information depending on the type of trigger. For DML triggers: The name of the owner of the table to which the trigger is attached. For DDL triggers: If database-wide then SYS; otherwise, the owner of the trigger For database event triggers: If database-wide then SYS; otherwise, the owner of the trigger For INSTEAD OF triggers: The owner of the view to which the trigger is attached For AFTER SUSPEND triggers: If database-wide then SYS; otherwise, the owner of the trigger |
| BASE_OBJECT_TYPE | The type of object to which the trigger is attached. For DML triggers: TABLE For DDL triggers: SCHEMA or DATABASE For database event triggers: SCHEMA or DATABASE For INSTEAD OF triggers: VIEW For AFTER SUSPEND triggers: SCHEMA or DATABASE |
| TABLE_NAME | For DML triggers: The name of the table the trigger is attached to. Other types of triggers: NULL |
| REFERENCING_NAMES | For DML (row-level) triggers: The clause used to define the aliases for the OLD and NEW records For other types of triggers: The text "REFERENCING NEW AS NEW OLD AS OLD" |
| WHEN_CLAUSE | For DML triggers: The trigger's conditional firing clause |
| STATUS | Trigger's status (ENABLED or DISABLED) |
| ACTION_TYPE | Indicates whether the trigger executes a call (CALL) or contains PL/SQL (PL/SQL). |
| TRIGGER_BODY | Text of the trigger body (LONG column) |
