The DBA_TRIGGERS view provides the information about all triggers in the database.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which a trigger belongs. |
schema_name | TEXT | The name of the schema to which the trigger belongs. |
trigger_name | TEXT | The name of the trigger. |
trigger_type | TEXT | The type of the trigger. Valid values:
|
triggering_event | TEXT | The event that activate the trigger. |
table_owner | TEXT | The username of the owner of the table on which the trigger is defined. |
base_object_type | TEXT | This parameter is supported for compatibility only. The value is TABLE. |
table_name | TEXT | The name of the table on which the trigger is defined. |
referencing_names | TEXT | This parameter is supported for compatibility only. The value is REFERENCING NEW AS NEW OLD AS OLD. |
status | TEXT | Indicates whether the trigger is enabled (VALID) or disabled (NOTVALID). |
description | TEXT | This parameter is supported for compatibility only. |
trigger_body | TEXT | The body of the trigger. |
action_statement | TEXT | The SQL statement that is executed when the trigger is activated. |