Using the DBA_TAB_COLUMNS View
SQL>
SQL> --
SQL>
SQL> select column_name,data_type, nullable from dba_tab_columns
2 where rownum < 50;
COLUMN_NAME
------------------------------
DATA_TYPE
--------------------------------------------------
N
-
SPARE6
DATE
Y
SPARE5
VARCHAR2
Y
SPARE4
VARCHAR2
Y
SPARE3
NUMBER
Y
SPARE2
NUMBER
Y
SPARE1
NUMBER
Y
INTCOL#
NUMBER
N
OFFSET
NUMBER
N
SEGCOLLENGTH
NUMBER
COLUMN_NAME
------------------------------
DATA_TYPE
--------------------------------------------------
N
-
N
SEGCOL#
NUMBER
N
POS#
NUMBER
N
COL#
NUMBER
N
BO#
NUMBER
N
OBJ#
NUMBER
N
SPARE6
DATE
Y
SPARE5
VARCHAR2
Y
SPARE4
VARCHAR2
Y
SPARE3
NUMBER
Y
SPARE2
NUMBER
Y
SPARE1
NUMBER
Y
CON#
NUMBER
N
NAME
VARCHAR2
N
OWNER#
NUMBER
N
SPARE6
DATE
Y
SPARE5
VARCHAR2
Y
SPARE4
VARCHAR2
Y
SPARE3
NUMBER
Y
SPARE2
NUMBER
Y
SPARE1
NUMBER
Y
FLAGS
NUMBER
Y
OPTIMAL
NUMBER
Y
KEEP
NUMBER
Y
UGRP#
NUMBER
Y
TS#
NUMBER
Y
STATUS$
NUMBER
N
INST#
NUMBER
Y
UNDOSQN
NUMBER
Y
XACTSQN
NUMBER
Y
SCNWRP
NUMBER
Y
SCNBAS
NUMBER
Y
BLOCK#
NUMBER
N
FILE#
NUMBER
N
USER#
NUMBER
N
NAME
VARCHAR2
N
US#
NUMBER
N
OBJ#
NUMBER
Y
ROLE#
NUMBER
N
PROXY#
NUMBER
N
CLIENT#
NUMBER
N
49 rows selected.
Related examples in the same category