Monday, September 26, 2016

DATABASE TRIGGER NOTES


  •  

    Triggers

    DATABASE TRIGGER NOTES:
  • Table Owner - Owner of the table
  • Table Name - Name of the table
  • Trigger Name - Name of the trigger
  • Trigger Name - When the trigger fires (BEFORE EACH ROW, AFTER EACH ROW, BEFORE STATEMENT, AFTER STATEMENT)
  • Triggering Event - Statement that fires the trigger (INSERT, UPDATE, DELETE)
  • Status - Whether the trigger is enabled (ENABLED or DISABLED)

    select  TABLE_OWNER,
     TABLE_NAME,
     TRIGGER_NAME,
     TRIGGER_TYPE,
     TRIGGERING_EVENT,
     STATUS
    from  dba_triggers
    order  by TABLE_NAME, TRIGGER_NAME
  • No comments:

    Post a Comment

    How To Fix Hive – Partition Table Query Failed When Stored As Parquet

    This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...