Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TRIGGERS

Triggers owned by the user

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com