Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Column Width Info
You'll find this information in user_tab_columns:
v734> desc user_tab_columns
Name Null? Type ------------------------------- -------- ---- TABLE_NAME NOT NULL VARCHAR2(30) COLUMN_NAME NOT NULL VARCHAR2(30) DATA_TYPE VARCHAR2(9) 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 v815> 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
data_precision gives you decimal precision for number and binary
precision for float.
data_scale gives you the number of digits to right of decimal point.
-- Have a nice day Michel Oleg Kuzmin <kuzmin_at_hotmail.com> a écrit dans le message : snc7ou1e6tt180_at_corp.supernews.com...Received on Thu Jul 20 2000 - 00:00:00 CDT
> Greetings!
>
> Probably it's a question of a newbie, but I cannot find a way to return the
> column width info in Oracle SQL. 'Desc tablename' gives the information for
> the whole table, and I need to select only the width of one of the columns.
>
> Thanks,
>
>
> Oleg
>
>
![]() |
![]() |