http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Ftemp_all_objects 2026-04-05T19:32:19Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/temp_all_objects&diff=3835&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/temp_all_objects&diff=3836&oldid=prev 2010-05-26T10:08:00Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Get all temporary objects from table temp_all_objects==<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; create global temporary table temp_all_objects<br /> 2 as<br /> 3 select * from all_objects where 1=0<br /> 4 /<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; create index temp_all_objects_idx on temp_all_objects(object_id)<br /> 2 /<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; insert into temp_all_objects<br /> 2 select * from all_objects where rownum &lt; 51<br /> 3 /<br /> 50 rows created.<br /> SQL&gt;<br /> SQL&gt; select * from temp_all_objects;<br /> <br /> OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_ TIMESTAMP STATUS T G S<br /> ------------------------------ ------------------------------ ------------------------------ ---------- -------------- ------------------- --------- --------- ------------------- ------- - - -<br /> SYS ICOL$ 20 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_USER1 44 44 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS CON$ 28 28 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS UNDO$ 15 15 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS C_COBJ# 29 29 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_OBJ# 3 3 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS PROXY_ROLE_DATA$ 25 25 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_IND1 39 39 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_CDEF2 51 51 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_PROXY_ROLE_DATA$_1 26 26 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS FILE$ 17 17 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS UET$ 13 8 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_FILE#_BLOCK# 9 9 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_FILE1 41 41 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_CON1 48 48 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_OBJ3 38 38 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_TS# 7 7 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_CDEF4 53 53 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS IND$ 19 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS SEG$ 14 8 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS C_TS# 6 6 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_FILE2 42 42 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS COL$ 21 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_TS1 43 43 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_UNDO2 35 35 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS CLU$ 5 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS PROXY_DATA$ 23 23 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_PROXY_DATA$ 24 24 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_OBJ1 36 36 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_COL2 46 46 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_OBJ2 37 37 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_CCOL1 54 54 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS TS$ 16 6 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS C_FILE#_BLOCK# 8 8 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS C_USER# 10 10 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_UNDO1 34 34 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS BOOTSTRAP$ 56 56 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS FET$ 12 6 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_TAB1 33 33 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS CCOL$ 32 29 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS USER$ 22 10 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_CON2 49 49 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_COBJ# 30 30 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS OBJ$ 18 18 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_COL3 47 47 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS C_OBJ# 2 2 CLUSTER 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS TAB$ 4 2 TABLE 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS CDEF$ 31 29 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_CDEF1 50 50 INDEX 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> SYS I_ICOL1 40 40 07-FEB-06 07-FEB-06 2006-02-07:22:10:08 VALID N N N<br /> <br /> 50 rows selected.<br /> SQL&gt;&lt;/source&gt;</div>

Admin