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...


> 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

>

>