Oracle PL/SQL/System Tables Views/dba triggers

Query dba_trigger table

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