The ALL_TRIGGERS view provides the information about the triggers on tables that may be accessed by the current user.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which the 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 that the table belongs to. The trigger is defined in this table. |
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_name | TEXT | This parameter is supported for compatibility only. The value is REFERENCING NEW AS NEW OLD AS OLD. |
status | TEXT | The status of the trigger. A value of VALID indicates that the trigger is enabled, and a value of NOTVALID indicates that the trigger is disabled. |
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 activates. |