http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FDBA_TAB_COLUMNS
Oracle PL/SQL/System Tables Views/DBA TAB COLUMNS - История изменений
2026-04-04T09:57:21Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/DBA_TAB_COLUMNS&diff=2240&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/DBA_TAB_COLUMNS&diff=2241&oldid=prev
Admin: 1 версия
2010-05-26T10:01:15Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Query column_name, hidden_column, data_type from DBA_TAB_COLS for a table name==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> create or replace type Job as object (<br />
2 firstname varchar2(30),<br />
3 surname varchar2(30),<br />
4 date_of_birth date,<br />
5 end_date date,<br />
6 item_count number(4),<br />
7 items_retrieved varchar2(1)<br />
8 )<br />
9 /<br />
Type created.<br />
SQL> create table Task (<br />
2 person_id number(10),<br />
3 job_detail Job<br />
4 );<br />
Table created.<br />
SQL><br />
SQL> set long 50000<br />
SQL> select text from dba_views where view_name = "DBA_TAB_COLUMNS"<br />
2 /<br />
TEXT<br />
--------------------------------------------------------------------------------<br />
select OWNER, TABLE_NAME,<br />
COLUMN_NAME, DATA_TYPE, DATA_TYPE_MOD, DATA_TYPE_OWNER,<br />
DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, COLUMN_ID,<br />
DEFAULT_LENGTH, DATA_DEFAULT, NUM_DISTINCT, LOW_VALUE, HIGH_VALUE,<br />
DENSITY, NUM_NULLS, NUM_BUCKETS, LAST_ANALYZED, SAMPLE_SIZE,<br />
CHARACTER_SET_NAME, CHAR_COL_DECL_LENGTH,<br />
GLOBAL_STATS, USER_STATS, AVG_COL_LEN, CHAR_LENGTH, CHAR_USED,<br />
V80_FMT_IMAGE, DATA_UPGRADED, HISTOGRAM<br />
from DBA_TAB_COLS<br />
where HIDDEN_COLUMN = "NO"<br />
<br />
1 row selected.<br />
SQL> select column_name, hidden_column, data_type from DBA_TAB_COLS where table_name = "TASK"<br />
2 /<br />
<br />
SQL> drop table Task;<br />
Table dropped.<br />
SQL><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Using the DBA_TAB_COLUMNS View==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> --<br />
SQL><br />
SQL> select column_name,data_type, nullable from dba_tab_columns<br />
2 where rownum < 50;<br />
COLUMN_NAME<br />
------------------------------<br />
DATA_TYPE<br />
--------------------------------------------------<br />
N<br />
-<br />
SPARE6<br />
DATE<br />
Y<br />
SPARE5<br />
VARCHAR2<br />
Y<br />
SPARE4<br />
VARCHAR2<br />
Y<br />
SPARE3<br />
NUMBER<br />
Y<br />
SPARE2<br />
NUMBER<br />
Y<br />
SPARE1<br />
NUMBER<br />
Y<br />
INTCOL#<br />
NUMBER<br />
N<br />
OFFSET<br />
NUMBER<br />
N<br />
SEGCOLLENGTH<br />
NUMBER<br />
<br />
COLUMN_NAME<br />
------------------------------<br />
DATA_TYPE<br />
--------------------------------------------------<br />
N<br />
-<br />
N<br />
SEGCOL#<br />
NUMBER<br />
N<br />
POS#<br />
NUMBER<br />
N<br />
COL#<br />
NUMBER<br />
N<br />
BO#<br />
NUMBER<br />
N<br />
OBJ#<br />
NUMBER<br />
N<br />
SPARE6<br />
DATE<br />
Y<br />
SPARE5<br />
VARCHAR2<br />
Y<br />
SPARE4<br />
VARCHAR2<br />
Y<br />
SPARE3<br />
NUMBER<br />
Y<br />
SPARE2<br />
NUMBER<br />
Y<br />
SPARE1<br />
NUMBER<br />
Y<br />
CON#<br />
NUMBER<br />
N<br />
NAME<br />
VARCHAR2<br />
N<br />
OWNER#<br />
NUMBER<br />
N<br />
SPARE6<br />
DATE<br />
Y<br />
SPARE5<br />
VARCHAR2<br />
Y<br />
SPARE4<br />
VARCHAR2<br />
Y<br />
SPARE3<br />
NUMBER<br />
Y<br />
SPARE2<br />
NUMBER<br />
Y<br />
SPARE1<br />
NUMBER<br />
Y<br />
FLAGS<br />
NUMBER<br />
Y<br />
OPTIMAL<br />
NUMBER<br />
Y<br />
KEEP<br />
NUMBER<br />
Y<br />
UGRP#<br />
NUMBER<br />
Y<br />
TS#<br />
NUMBER<br />
Y<br />
STATUS$<br />
NUMBER<br />
N<br />
INST#<br />
NUMBER<br />
Y<br />
UNDOSQN<br />
NUMBER<br />
Y<br />
XACTSQN<br />
NUMBER<br />
Y<br />
SCNWRP<br />
NUMBER<br />
Y<br />
SCNBAS<br />
NUMBER<br />
Y<br />
BLOCK#<br />
NUMBER<br />
N<br />
FILE#<br />
NUMBER<br />
N<br />
USER#<br />
NUMBER<br />
N<br />
NAME<br />
VARCHAR2<br />
N<br />
US#<br />
NUMBER<br />
N<br />
OBJ#<br />
NUMBER<br />
Y<br />
ROLE#<br />
NUMBER<br />
N<br />
PROXY#<br />
NUMBER<br />
N<br />
CLIENT#<br />
NUMBER<br />
N<br />
<br />
49 rows selected.<br />
<br />
</source></div>
Admin