System Tables Data Dictionary Oracle PLSQL Tutorial

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>