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>