ALL_TRIGGERS

Triggers accessible to the current user

Columns
   ___________________________
 
   OWNER
      Owner of the trigger
   TRIGGER_NAME
      Name of the trigger
   TRIGGER_TYPE
      When the trigger fires - BEFORE/AFTER and STATEMENT/ROW
   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
   WHEN_CLAUSE
      WHEN clause must evaluate to true in order for triggering body to execute
   STATUS
      If DISABLED then trigger will not fire
   DESCRIPTION
      Trigger description
   ACTION_TYPE
      --
   TRIGGER_BODY
      Action taken by this trigger when it fires

Related:


© Copyright SS64.com 1999-2014
Some rights reserved