http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fobject_table 2026-05-24T09:58:21Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/object_table&diff=3959&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://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/object_table&diff=3960&oldid=prev 2010-05-26T10:08:13Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== List tables and views from object_table==<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; select object_name, object_type<br /> 2 from obj<br /> 3 where object_type in (&quot;TABLE&quot;,&quot;VIEW&quot;)<br /> 4 and rownum &lt; 50<br /> 5 order by object_type, object_name;<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> AVAIL_TRACE_FILES<br /> TABLE<br /> DDL_AUDIT<br /> TABLE<br /> DUMMY<br /> TABLE<br /> HAZARD_LEVEL_T<br /> TABLE<br /> HOME_ADDRESES_TAB<br /> TABLE<br /> HOME_ADDRESS_LIST<br /> TABLE<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> I1<br /> TABLE<br /> I2<br /> TABLE<br /> INTEREST<br /> TABLE<br /> LOG_TABLE<br /> TABLE<br /> MAP<br /> TABLE<br /> OUTRAIN<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> TABLE<br /> P<br /> TABLE<br /> PARTS<br /> TABLE<br /> PUBLICATION<br /> TABLE<br /> SITE_TAB<br /> TABLE<br /> T1_TIMES<br /> TABLE<br /> <br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> TEST_BFILE<br /> TABLE<br /> WORKING_CUSTOMERS<br /> TABLE<br /> APPLICATION_USERS<br /> VIEW<br /> AUTHOR_PUBLICATION<br /> VIEW<br /> AVG_EVALUATIONS<br /> VIEW<br /> COURSE_DAYS<br /> VIEW<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> CRS_COURSE_SCHEDULE<br /> VIEW<br /> CRS_OFFERINGS<br /> VIEW<br /> DEPT20_V<br /> VIEW<br /> DEPT_OR<br /> VIEW<br /> EMP_V<br /> VIEW<br /> EMP_VIEW<br /> OBJECT_NAME<br /> --------------------------------------------------------------------------------<br /> OBJECT_TYPE<br /> -------------------<br /> VIEW<br /> HRC_ORG_SITE<br /> VIEW<br /> SALES_BY_ATLAS_V<br /> VIEW<br /> SALES_PER_PERSON_V<br /> VIEW<br /> USER_AVAIL_TRACE_FILES<br /> VIEW<br /> <br /> 33 rows selected.<br /> SQL&gt;&lt;/source&gt;</div>

Admin