http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fdba_triggersOracle PL/SQL/System Tables Views/dba triggers - История изменений2026-05-24T06:05:22ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_triggers&diff=2246&oldid=prev в 13:45, 26 мая 20102010-05-26T13:45:19Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_triggers&diff=2247&oldid=prevAdmin: 1 версия2010-05-26T10:01:16Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Query dba_trigger table==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> set linesize 77<br />
SQL> column triggering_event format a30<br />
SQL> column trigger_name format a20<br />
SQL><br />
SQL> select trigger_name,<br />
2 triggering_event,<br />
3 trigger_type,<br />
4 status<br />
5 from dba_triggers<br />
6 where rownum < 50<br />
7 /<br />
TRIGGER_NAME TRIGGERING_EVENT TRIGGER_TYPE<br />
-------------------- ------------------------------ ----------------<br />
STATUS<br />
----------<br />
DEF$_PROPAGATOR_TRIG INSERT BEFORE STATEMENT<br />
ENABLED<br />
REPCATLOGTRIG UPDATE OR DELETE AFTER STATEMENT<br />
ENABLED<br />
XDB_RV_TRIG INSERT OR UPDATE OR DELETE INSTEAD OF<br />
ENABLED<br />
XDB$ACL$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
xdb-log44_TAB$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
SERVLET$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
ftp-log65_TAB$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
http-log86_TAB$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
Folder103_TAB$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
XDB_PV_TRIG INSERT OR UPDATE OR DELETE INSTEAD OF<br />
ENABLED<br />
XDB$STATS$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
XDB$CONFIG$xd UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
XDBCONFIG_VALIDATE INSERT OR UPDATE BEFORE EACH ROW<br />
ENABLED<br />
SDO_GEOM_TRIG_INS1 INSERT INSTEAD OF<br />
ENABLED<br />
SDO_GEOM_TRIG_DEL1 DELETE INSTEAD OF<br />
ENABLED<br />
SDO_GEOM_TRIG_UPD1 UPDATE INSTEAD OF<br />
ENABLED<br />
SDO_LRS_TRIG_INS INSERT INSTEAD OF<br />
ENABLED<br />
SDO_LRS_TRIG_DEL DELETE INSTEAD OF<br />
ENABLED<br />
SDO_COORD_OP_METHODS INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
_TRIGGER<br />
ENABLED<br />
SDO_LRS_TRIG_UPD UPDATE INSTEAD OF<br />
ENABLED<br />
SDO_TOPO_TRIG_INS1 INSERT INSTEAD OF<br />
ENABLED<br />
SDO_PREFERRED_OPS_SY INSERT OR UPDATE BEFORE EACH ROW<br />
S_TRIGGER<br />
ENABLED<br />
SDO_PREFERRED_OPS_US INSERT OR UPDATE BEFORE EACH ROW<br />
ER_TRIGGER<br />
ENABLED<br />
SDO_COORD_OP_PATHS_T INSERT OR UPDATE BEFORE EACH ROW<br />
RIGGER<br />
ENABLED<br />
CS_SRS_TRIGGER INSERT OR UPDATE OR DELETE INSTEAD OF<br />
ENABLED<br />
SDO_CRS_INSERT_TRIGG INSERT INSTEAD OF<br />
ER<br />
ENABLED<br />
SDO_CRS_DELETE_TRIGG DELETE INSTEAD OF<br />
ER<br />
ENABLED<br />
OGIS_CRS_INSERT_TRIG INSERT BEFORE EACH ROW<br />
GER<br />
ENABLED<br />
OGIS_CRS_DELETE_TRIG DELETE BEFORE EACH ROW<br />
GER<br />
ENABLED<br />
SECURE_EMPLOYEES INSERT OR UPDATE OR DELETE BEFORE STATEMENT<br />
DISABLED<br />
UPDATE_JOB_HISTORY UPDATE AFTER EACH ROW<br />
ENABLED<br />
WWV_BIU_FLOW_FEEDBAC INSERT OR UPDATE BEFORE EACH ROW<br />
K<br />
ENABLED<br />
WWV_BIU_FLOW_BUILD_A INSERT OR UPDATE BEFORE EACH ROW<br />
UDIT_T<br />
ENABLED<br />
WWV_BIU_FLOWS_AUDIT INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
ENABLED<br />
WWV_BIU_FLOW_TMPLTS_ INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
AUDIT<br />
ENABLED<br />
WWV_BIU_FLOW_ICON_BA INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
R_AUDIT<br />
ENABLED<br />
WWV_BIU_PROCESSING_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
UDIT<br />
ENABLED<br />
WWV_BIU_FLOW_ITEMS_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
UDIT<br />
ENABLED<br />
WWV_BIU_COMPUTATIONS INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
_AUDIT<br />
ENABLED<br />
WWV_BIU_FLOW_TABS_AU INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
DIT<br />
ENABLED<br />
WWV_BIU_FLOW_TL_TABS INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
_AUDIT<br />
ENABLED<br />
WWV_BIU_FLOW_LOV_AUD INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
IT<br />
ENABLED<br />
WWV_BIU_FLOW_LOVD_AU INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
DIT<br />
ENABLED<br />
WWV_BIU_FLOW_STEPS_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
UDIT<br />
ENABLED<br />
WWV_BIU_STEP_BUTTONS INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
_AUDIT<br />
ENABLED<br />
WWV_BIU_STEP_BRANCHE INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
S_AUDIT<br />
ENABLED<br />
WWV_BIU_STEP_BRANCH_ INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
ARGS_AUDIT<br />
ENABLED<br />
WWV_BIU_STEP_ITEMS_A INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
UDIT<br />
ENABLED<br />
WWV_BIU_FLOW_MENU_OP INSERT OR UPDATE OR DELETE BEFORE EACH ROW<br />
T_AUDIT<br />
ENABLED<br />
<br />
49 rows selected.<br />
SQL> --<br />
</source></div>Admin