Oracle PL/SQL/System Tables Views/dba triggers

Query dba_trigger table

   <source lang="sql">

SQL> SQL> set linesize 77 SQL> column triggering_event format a30 SQL> column trigger_name format a20 SQL> SQL> select trigger_name,

 2            triggering_event,
 3             trigger_type,
 4             status
 5        from dba_triggers
 6       where rownum < 50
 7      /

TRIGGER_NAME TRIGGERING_EVENT TRIGGER_TYPE

---

------------------------------ ----------------

STATUS

---

DEF$_PROPAGATOR_TRIG INSERT BEFORE STATEMENT ENABLED REPCATLOGTRIG UPDATE OR DELETE AFTER STATEMENT ENABLED XDB_RV_TRIG INSERT OR UPDATE OR DELETE INSTEAD OF ENABLED XDB$ACL$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED xdb-log44_TAB$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED SERVLET$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED ftp-log65_TAB$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED http-log86_TAB$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED Folder103_TAB$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED XDB_PV_TRIG INSERT OR UPDATE OR DELETE INSTEAD OF ENABLED XDB$STATS$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED XDB$CONFIG$xd UPDATE OR DELETE BEFORE EACH ROW ENABLED XDBCONFIG_VALIDATE INSERT OR UPDATE BEFORE EACH ROW ENABLED SDO_GEOM_TRIG_INS1 INSERT INSTEAD OF ENABLED SDO_GEOM_TRIG_DEL1 DELETE INSTEAD OF ENABLED SDO_GEOM_TRIG_UPD1 UPDATE INSTEAD OF ENABLED SDO_LRS_TRIG_INS INSERT INSTEAD OF ENABLED SDO_LRS_TRIG_DEL DELETE INSTEAD OF ENABLED SDO_COORD_OP_METHODS INSERT OR UPDATE OR DELETE BEFORE EACH ROW _TRIGGER ENABLED SDO_LRS_TRIG_UPD UPDATE INSTEAD OF ENABLED SDO_TOPO_TRIG_INS1 INSERT INSTEAD OF ENABLED SDO_PREFERRED_OPS_SY INSERT OR UPDATE BEFORE EACH ROW S_TRIGGER ENABLED SDO_PREFERRED_OPS_US INSERT OR UPDATE BEFORE EACH ROW ER_TRIGGER ENABLED SDO_COORD_OP_PATHS_T INSERT OR UPDATE BEFORE EACH ROW RIGGER ENABLED CS_SRS_TRIGGER INSERT OR UPDATE OR DELETE INSTEAD OF ENABLED SDO_CRS_INSERT_TRIGG INSERT INSTEAD OF ER ENABLED SDO_CRS_DELETE_TRIGG DELETE INSTEAD OF ER ENABLED OGIS_CRS_INSERT_TRIG INSERT BEFORE EACH ROW GER ENABLED OGIS_CRS_DELETE_TRIG DELETE BEFORE EACH ROW GER ENABLED SECURE_EMPLOYEES INSERT OR UPDATE OR DELETE BEFORE STATEMENT DISABLED UPDATE_JOB_HISTORY UPDATE AFTER EACH ROW ENABLED WWV_BIU_FLOW_FEEDBAC INSERT OR UPDATE BEFORE EACH ROW K ENABLED WWV_BIU_FLOW_BUILD_A INSERT OR UPDATE BEFORE EACH ROW UDIT_T ENABLED WWV_BIU_FLOWS_AUDIT INSERT OR UPDATE OR DELETE BEFORE EACH ROW ENABLED WWV_BIU_FLOW_TMPLTS_ INSERT OR UPDATE OR DELETE BEFORE EACH ROW AUDIT ENABLED WWV_BIU_FLOW_ICON_BA INSERT OR UPDATE OR DELETE BEFORE EACH ROW R_AUDIT ENABLED WWV_BIU_PROCESSING_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW UDIT ENABLED WWV_BIU_FLOW_ITEMS_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW UDIT ENABLED WWV_BIU_COMPUTATIONS INSERT OR UPDATE OR DELETE BEFORE EACH ROW _AUDIT ENABLED WWV_BIU_FLOW_TABS_AU INSERT OR UPDATE OR DELETE BEFORE EACH ROW DIT ENABLED WWV_BIU_FLOW_TL_TABS INSERT OR UPDATE OR DELETE BEFORE EACH ROW _AUDIT ENABLED WWV_BIU_FLOW_LOV_AUD INSERT OR UPDATE OR DELETE BEFORE EACH ROW IT ENABLED WWV_BIU_FLOW_LOVD_AU INSERT OR UPDATE OR DELETE BEFORE EACH ROW DIT ENABLED WWV_BIU_FLOW_STEPS_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW UDIT ENABLED WWV_BIU_STEP_BUTTONS INSERT OR UPDATE OR DELETE BEFORE EACH ROW _AUDIT ENABLED WWV_BIU_STEP_BRANCHE INSERT OR UPDATE OR DELETE BEFORE EACH ROW S_AUDIT ENABLED WWV_BIU_STEP_BRANCH_ INSERT OR UPDATE OR DELETE BEFORE EACH ROW ARGS_AUDIT ENABLED WWV_BIU_STEP_ITEMS_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW UDIT ENABLED WWV_BIU_FLOW_MENU_OP INSERT OR UPDATE OR DELETE BEFORE EACH ROW T_AUDIT ENABLED

49 rows selected. SQL> --

</source>