find out all triggers from user_triggers table : user_triggers « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_triggers

SQL>
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>
SQL>