Using the DBA_TAB_COLUMNS View : DBA_TAB_COLUMNS « System Tables Views « Oracle PL / SQL






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

1.Query column_name, hidden_column, data_type from DBA_TAB_COLS for a table name