Re: SQL Script to do a Describe

It's all in the user_tab_columns and/or all_tab_columns...

select

   column_name,
   decode(nullable, 'Y', '', 'NOT NULL') Nulls, data_type ||

      '(' || to_char(data_length) ||')' Type from user_tab_columns
where table_name = (mytable)

This should get you close... just replace (mytable) with 'table_i_am_looking_for'

JP

rkg100_at_erols.com (Ryan Gaffuri) wrote in message news:<6757365f.0203280638.3b39a76d_at_posting.google.com>...
> Anyone know where I can grab a SQL script that will format a data
> dictionary query just like a describe? need to get some data
> dictionary data on multiple tables.
>
> Thanks.
Received on Thu Mar 28 2002 - 13:51:49 CST