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