ALL_TRIGGERS

Triggers accessible to the current user
Columns
   ___________________________
 
   WHEN_CLAUSE
      WHEN clause must evaluate to true in order for triggering body to execute
   TRIGGER_BODY
      Action taken by this trigger when it fires
   ACTION_TYPE
   TRIGGER_TYPE
      When the trigger fires - BEFORE/AFTER and STATEMENT/ROW
   STATUS
      If DISABLED then trigger will not fire
   DESCRIPTION
      Trigger description, useful for re-creating trigger creation statement
   TRIGGER_NAME
      Name of the trigger
   TRIGGERING_EVENT
      Statement that will fire the trigger - INSERT, UPDATE and/or DELETE
   TABLE_OWNER
      Owner of the table that this trigger is associated with
   BASE_OBJECT_TYPE
   TABLE_NAME
      Name of the table that this trigger is associated with
   COLUMN_NAME
      The name of the column on which the trigger is defined over
   REFERENCING_NAMES
      Names used for referencing to OLD and NEW values within the trigger
   OWNER
      Owner of the trigger
Related Commands:
Simon Sheppard
SS64.com