Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Column Structure!
Maxx wrote:
>
> How does one extract the column structures for one table only from
> user_tables_columns? The describe command is insufficient here. If anyone
> has any suggestions, I'd be profounfly appreciative.
SELECT
cols.column_name AS Name,
nullable,
data_type AS TYPE,
DECODE( data_type,
'NUMBER',
data_precision + data_scale, data_length ) LENGTH, data_precision Precision, data_scale Scale, data_length dlength, data_default ,
I plagiarized this from T.O.A.D's SQL spooler.
Yours,
Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys
Received on Mon Mar 27 2000 - 05:05:35 CST