http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fall_tab_columns 2026-05-23T21:11:04Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/all_tab_columns&diff=3903&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/all_tab_columns&diff=3904&oldid=prev 2010-05-26T10:08:05Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Get information on all the columns in tables you have access to using all_tab_columns.==<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; desc all_tab_columns;<br /> Name Null? Type<br /> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------------------------------------------------------<br /> OWNER NOT NULL VARCHAR2(30)<br /> TABLE_NAME NOT NULL VARCHAR2(30)<br /> COLUMN_NAME NOT NULL VARCHAR2(30)<br /> DATA_TYPE VARCHAR2(106)<br /> DATA_TYPE_MOD VARCHAR2(3)<br /> DATA_TYPE_OWNER VARCHAR2(30)<br /> DATA_LENGTH NOT NULL NUMBER<br /> DATA_PRECISION NUMBER<br /> DATA_SCALE NUMBER<br /> NULLABLE VARCHAR2(1)<br /> COLUMN_ID NUMBER<br /> DEFAULT_LENGTH NUMBER<br /> DATA_DEFAULT LONG<br /> NUM_DISTINCT NUMBER<br /> LOW_VALUE RAW(32)<br /> HIGH_VALUE RAW(32)<br /> DENSITY NUMBER<br /> NUM_NULLS NUMBER<br /> NUM_BUCKETS NUMBER<br /> LAST_ANALYZED DATE<br /> SAMPLE_SIZE NUMBER<br /> CHARACTER_SET_NAME VARCHAR2(44)<br /> CHAR_COL_DECL_LENGTH NUMBER<br /> GLOBAL_STATS VARCHAR2(3)<br /> USER_STATS VARCHAR2(3)<br /> AVG_COL_LEN NUMBER<br /> CHAR_LENGTH NUMBER<br /> CHAR_USED VARCHAR2(1)<br /> V80_FMT_IMAGE VARCHAR2(3)<br /> DATA_UPGRADED VARCHAR2(3)<br /> HISTOGRAM VARCHAR2(15)<br /> SQL&gt;<br /> SQL&gt; --select * from all_tab_columns;&lt;/source&gt;</div>

Admin