http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fobj Oracle PL/SQL/System Tables Views/obj - История изменений 2026-06-10T17:10:38Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/obj&diff=2166&oldid=prev в 13:45, 26 мая 2010 2010-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/obj&diff=2167&oldid=prev Admin: 1 версия 2010-05-26T10:01:05Z <p>1 версия</p> <p><b>Новая страница</b></p><div>==Table and view from obj==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; select object_name, object_type<br /> 2 from obj<br /> 3 where object_type in (&quot;TABLE&quot;,&quot;VIEW&quot;)<br /> 4 order by object_type, object_name;<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> CUSTLOG<br /> TABLE<br /> CUST_NO_KEY_TABLE<br /> TABLE<br /> CUST_WITH_VARRAY_TEMP_TABLE<br /> TABLE<br /> DEMO<br /> TABLE<br /> DEPT$AUDIT<br /> TABLE<br /> E<br /> TABLE<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> EMP_DELTAS<br /> TABLE<br /> EMPLOYEETEMPTABLE<br /> TABLE<br /> EMPTEMPTABLE<br /> TABLE<br /> INVENTORY_TBL<br /> TABLE<br /> IT<br /> TABLE<br /> IX<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> TABLE<br /> MYSTATS<br /> TABLE<br /> MYTABLE1<br /> TABLE<br /> P<br /> TABLE<br /> PARMS<br /> TABLE<br /> PASSWORD_AUDIT<br /> TABLE<br /> <br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> P1<br /> TABLE<br /> SYSTEM_STATS<br /> TABLE<br /> TEMP_TABLE<br /> TABLE<br /> TMP<br /> TABLE<br /> WORKING_CUSTOMERS<br /> TABLE<br /> WORKING_EMPLOYEES<br /> TABLE<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> WORKING_EMPS<br /> TABLE<br /> ALL_ORACLE_ERRORS<br /> VIEW<br /> AVG_SAL<br /> VIEW<br /> DEPT_SAL<br /> VIEW<br /> EMP_BONUS<br /> VIEW<br /> EMPDEPT_V<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> VIEW<br /> EMP_HQ<br /> VIEW<br /> INVENTORY_VIE<br /> VIEW<br /> PHONE_LIST<br /> VIEW<br /> SHARED<br /> VIEW<br /> TOP_EMP<br /> VIEW<br /> <br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> V<br /> VIEW<br /> <br /> 35 rows selected.<br /> SQL&gt;<br /> SQL&gt;<br /> <br /> <br /> <br /> <br /> &lt;/source&gt;</div> Admin