dba_tab_columns

From: Taji <gabsaga_tata_at_hotmail.com>
Date: 14 Jul 2003 14:17:16 -0700
Message-ID: <15619060.0307141317.6953695e@posting.google.com>

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. Received on Mon Jul 14 2003 - 16:17:16 CDT