Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Column Width Info

Re: Column Width Info

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/07/20
Message-ID: <8l6ahq$1dfd$1@s2.feed.news.oleane.net>#1/1

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
>
>
Received on Thu Jul 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US