http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2FDICTIONARY 2026-05-25T16:54:47Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/DICTIONARY&diff=3753&oldid=prev 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/DICTIONARY&diff=3754&oldid=prev 2010-05-26T10:07:52Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== List table name from dictionary==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; COLUMN table_name FORMAT a20<br /> SQL&gt; COLUMN comments FORMAT a55<br /> SQL&gt; SELECT *<br /> 2 FROM DICTIONARY<br /> 3 WHERE table_name LIKE &quot;%DEPEND%&quot;<br /> 4 and rownum &lt; 50;<br /> TABLE_NAME COMMENTS<br /> -------------------- -------------------------------------------------------<br /> ALL_REFRESH_DEPENDEN Description of the detail tables that materialized view<br /> CIES s depend on for<br /> refresh<br /> USER_DEPENDENCIES Dependencies to and from a users objects<br /> ALL_DEPENDENCIES Dependencies to and from objects accessible to the user<br /> DBA_DEPENDENCIES Dependencies to and from objects<br /> V$OBJECT_DEPENDENCY Synonym for V_$OBJECT_DEPENDENCY<br /> GV$OBJECT_DEPENDENCY Synonym for GV_$OBJECT_DEPENDENCY<br /> DBA_APPLY_VALUE_DEPE Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS<br /> NDENCIES<br /> TABLE_NAME COMMENTS<br /> -------------------- -------------------------------------------------------<br /> DBA_APPLY_OBJECT_DEP Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS<br /> ENDENCIES<br /> <br /> 8 rows selected.<br /> SQL&gt;&lt;/source&gt;</div>

Admin