Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TRIGGERS

Triggers owned by the user

Columns
   ___________________________
 
   TRIGGER_NAME
      Name of the trigger
   TRIGGER_TYPE
      Type of the trigger (when it 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
   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:



Simon Sheppard
SS64.com