http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fdba_dependencies
Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba dependencies - История изменений
2026-07-15T07:56:36Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_dependencies&diff=3935&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:46Z
<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://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/dba_dependencies&diff=3936&oldid=prev
Admin: 1 версия
2010-05-26T10:08:09Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Find out dependencies from dba_dependencies==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL> --<br />
SQL><br />
SQL><br />
SQL> BREAK ON r_name SKIP 1<br />
SQL> COLUMN r_name FORMAT a80<br />
SQL> COLUMN name FORMAT a80<br />
SQL> COLUMN r_link FORMAT a80<br />
SQL> SET HEADING OFF<br />
SQL> SELECT DECODE(referenced_type, "NON-EXISTENT", ".....",<br />
2 referenced_type) || " " || referenced_owner ||<br />
3 "." || referenced_name r_name, " is referenced by: " ||<br />
4 type || " " || owner || "." || name name,<br />
5 " Referenced Link: " || DECODE(referenced_link_name,<br />
6 NULL, "none", referenced_link_name) r_link<br />
7 FROM dba_dependencies<br />
8 WHERE owner NOT IN ("SYS", "SYSTEM")<br />
9 and rownum < 50<br />
10 ORDER BY 1,2;<br />
TABLE SYS.CCOL$<br />
is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS<br />
Referenced Link: none<br />
<br />
TABLE SYS.COL$<br />
is referenced by: PACKAGE BODY CTXSYS.DRICON<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRIREPZ<br />
Referenced Link: none<br />
<br />
TABLE SYS.COL$<br />
is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS<br />
Referenced Link: none<br />
<br />
TABLE SYS.CON$<br />
is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS<br />
Referenced Link: none<br />
<br />
TABLE SYS.ICOL$<br />
is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS<br />
Referenced Link: none<br />
<br />
TABLE SYS.IND$<br />
is referenced by: PACKAGE BODY CTXSYS.DRIREPZ<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRIUTL<br />
Referenced Link: none<br />
<br />
is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS<br />
Referenced Link: none<br />
<br />
TABLE SYS.TS$<br />
is referenced by: PACKAGE BODY CTXSYS.DRIREPZ<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_XE_CONFIG<br />
Referenced Link: none<br />
<br />
TABLE SYS.USER$<br />
is referenced by: PACKAGE BODY CTXSYS.DRIACC<br />
Referenced Link: none<br />
TABLE SYS.USER$<br />
is referenced by: PACKAGE BODY CTXSYS.DRICON<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRIIXS<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRIPREF<br />
Referenced Link: none<br />
<br />
TABLE SYS.USER$<br />
is referenced by: PACKAGE BODY CTXSYS.DRIREPZ<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRISGP<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRISPL<br />
Referenced Link: none<br />
<br />
TABLE SYS.USER$<br />
is referenced by: PACKAGE BODY CTXSYS.DRITHSC<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRIUTL<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRIVAL<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY CTXSYS.DRIXMD<br />
Referenced Link: none<br />
TABLE SYS.USER$<br />
is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_IMP_PARSER<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_PROVISIONING<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_SW_API<br />
Referenced Link: none<br />
TABLE SYS.USER$<br />
is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_THEME_FILES<br />
Referenced Link: none<br />
<br />
is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_XE_PROVISION<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_INDEXES<br />
Referenced Link: none<br />
<br />
TABLE SYS.USER$<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_ERRORS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_OBJECTS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_PARTITIONS<br />
Referenced Link: none<br />
<br />
TABLE SYS.USER$<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_SETS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_SET_INDEXES<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_SUB_LEXERS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_SUB_LEXER_VALUES<br />
Referenced Link: none<br />
TABLE SYS.USER$<br />
is referenced by: VIEW CTXSYS.CTX_INDEX_VALUES<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_PENDING<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_PREFERENCE_VALUES<br />
Referenced Link: none<br />
TABLE SYS.USER$<br />
is referenced by: VIEW CTXSYS.CTX_SECTIONS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_SECTION_GROUPS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_SQES<br />
Referenced Link: none<br />
<br />
TABLE SYS.USER$<br />
is referenced by: VIEW CTXSYS.CTX_STOPLISTS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_STOPWORDS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_SUB_LEXERS<br />
Referenced Link: none<br />
<br />
TABLE SYS.USER$<br />
is referenced by: VIEW CTXSYS.CTX_THESAURI<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_USER_INDEXES<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_USER_INDEX_PARTITIONS<br />
Referenced Link: none<br />
<br />
is referenced by: VIEW CTXSYS.CTX_USER_SQES<br />
Referenced Link: none<br />
TABLE SYS.USER$<br />
is referenced by: VIEW CTXSYS.CTX_USER_SUB_LEXERS<br />
Referenced Link: none<br />
<br />
49 rows selected.<br />
SQL></source></div>
Admin