Getting Information on Triggers

The user_triggers view has information on your triggers. Some of the columns in user_triggers:

ColumnTypeDescription
TRIGGER_NAMEVARCHAR2(30)Name of the trigger.
TRIGGER_TYPEVARCHAR2(16)Type of the trigger.
TRIGGERING_EVENTVARCHAR2(227)Event that causes the trigger to fire.
TABLE_OWNERVARCHAR2(30)table owners.
BASE_OBJECT_TYPEVARCHAR2(16)Type of the object referenced.
TABLE_NAMEVARCHAR2(30)Name of the table referenced by the trigger.
COLUMN_NAMEVARCHAR2(4000)Name of the column referenced by the trigger.
REFERENCING_NAMESVARCHAR2(128)Name of the old and new aliases.
WHEN_CLAUSEVARCHAR2(4000)Trigger condition
STATUSVARCHAR2(8)ENABLED or DISABLED
DESCRIPTIONVARCHAR2(4000)Description of the trigger.
ACTION_TYPEVARCHAR2(11)Action type of the trigger (CALL or PL/SQL).
TRIGGER_BODYLONGCode contained in the trigger body.

The all_triggers has information on all the triggers you have access to.


SELECT trigger_name, trigger_type, triggering_event, 
       table_ownerbase_object_type, table_name, referencing_names, when_clause, status,
       description, action_type, trigger_body
FROM user_triggers
WHERE trigger_name = 'BEFORE_EMP_UPDATE';
Home »
Oracle »
PL/SQL » 

Triggers:
  1. Triggers
  2. Getting Information on Triggers
  3. Disabling and Enabling a Trigger
  4. Dropping a Trigger
Related: