|
|
Re: Retrieving data about a table (e.g., column names) [message #7057 is a reply to message #7040] |
Mon, 19 May 2003 02:08 |
Gilbey
Messages: 87 Registered: March 2002
|
Member |
|
|
Use this..
SQL> desc user_tab_columns;
Name Null? Type
----------------------------------------- -------- ---------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME NOT NULL VARCHAR2(30)
DATA_TYPE VARCHAR2(106)
DATA_TYPE_MOD VARCHAR2(3)
DATA_TYPE_OWNER VARCHAR2(30)
DATA_LENGTH NOT NULL NUMBER
DATA_PRECISION NUMBER
DATA_SCALE NUMBER
NULLABLE VARCHAR2(1)
COLUMN_ID NOT NULL NUMBER
DEFAULT_LENGTH NUMBER
DATA_DEFAULT LONG
NUM_DISTINCT NUMBER
LOW_VALUE RAW(32)
HIGH_VALUE RAW(32)
DENSITY NUMBER
NUM_NULLS NUMBER
NUM_BUCKETS NUMBER
LAST_ANALYZED DATE
SAMPLE_SIZE NUMBER
CHARACTER_SET_NAME VARCHAR2(44)
CHAR_COL_DECL_LENGTH NUMBER
GLOBAL_STATS VARCHAR2(3)
USER_STATS VARCHAR2(3)
AVG_COL_LEN NUMBER
SQL> select COLUMN_NAME from user_tab_columns
2 where table_name='TEMP';
COLUMN_NAME
-------------------------------------------------------------------------------
SNO
AMOUNT
Gilbey
|
|
|
|