Re: Help! Script needed...

MCC wrote:
>
> Hi Oracle Gurus,
>
> Does anyone have an working script that will list all the tables
> that have the same column names? For a particular column name, I need
> to know what tables have it. Instead of DESCRIB every tables in the
> database, a working script will be highly appreciated.
>
> Thanks,
> Edith

Edith,

Try:

   select table_name from all_tab_columns where column_name=<name>

Ken Denny
Insight Industries, Inc.
RTP, NC
kdenny_at_interpath.com Received on Wed Dec 11 1996 - 00:00:00 CET