Re: Select statement that returns field size?

From: sandeep pande <sandy.soft80_at_gmail.com>
Date: Tue, 11 May 2010 00:10:47 -0700 (PDT)
Message-ID: <36c8be52-16f2-44e4-bbb5-bf0c41d9d680_at_32g2000prq.googlegroups.com>

On May 5, 11:05�pm, Rich <richma..._at_earthlink.net> wrote:
> I am using 10g.
>
> I want to do a select statement that will give me the name of the
> fields in a table. And I also want to know the field type and field
> size.
>
> Can this be done?
>
> Regards

Hi,

Yes u can do this using

SQL> desc dba_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) select table_name,column_name,data_type,DATA_LENGTH from dba_tab_columns where table_ name='<table_name>' and owner='<username>' Received on Tue May 11 2010 - 02:10:47 CDT