|
|
| Re: How can I get the info on tables and columns and their data types. [message #404467 is a reply to message #404466] |
Thu, 21 May 2009 21:13   |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
SQL> desc all_tab_columns
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
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 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
CHAR_LENGTH NUMBER
CHAR_USED VARCHAR2(1)
V80_FMT_IMAGE VARCHAR2(3)
DATA_UPGRADED VARCHAR2(3)
HISTOGRAM VARCHAR2(15)
Oracle has many views to answer questions similar to what you asked.
These views begin with
DBA_
ALL_
USER_
where DBA_ list everything in DB, ALL_ list everything you have SELECT privs against, & USER_ everything owned by your schema.
To see what might hold the answer you desire about COLUMNS do:
SELECT VIEW_NAME FROM DBA_VIEW WHERE VIEW_NAME LIKE '%COLUMN%';
To see what might hold the answer you desire about COMMENT do:
SELECT VIEW_NAME FROM DBA_VIEW WHERE VIEW_NAME LIKE '%COMMENT%';
[Updated on: Thu, 21 May 2009 21:20] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
