Re: dba_tab_columns

On 14 Jul 2003 14:17:16 -0700, gabsaga_tata_at_hotmail.com (Taji) wrote:

>Does anyone happen to know the exact select statement that the
>'describe' command emulates? I tried something like the following but
>it didn't exactly work 'cause when the data_type is a VARCHAR, it
>doesn't show the number of characters.
>
>select column_name, decode (nullable, 'Y', 'NULL','NOT NULL') ,
>data_type,
>data_precision,
>data_scale
>from dba_tab_columns
>where table_name = 'TABLE_NAME_GOES_HERE' order by column_id"
>
>Thanks.
>
>Taji.

I don't think your assertion is correct. IIRC there is a data_length column which is being used in non-numeric columns Just describe dba_tab_columns, grin

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jul 14 2003 - 17:28:21 CDT