Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Find out all triggers from user_triggers table

SQL> SQL> SELECT    table_name, trigger_name, trigger_type type,   2            triggering_event event, status   3  FROM      user_triggers   4  where     rownum < 2   5  ORDER BY  table_name; TABLE_NAME           TRIGGER_NAME                   TYPE -------------------- ------------------------------ ---------------- EVENT -------------------------------------------------------------------------------- STATUS -------- HRC_ORG_SITE         HRC_ORG_SITE_TRIG              INSTEAD OF INSERT OR UPDATE OR DELETE DISABLED SQL>