From: Ken Denny <kdenny@interpath.com>
Subject: Re: Help! Script needed...
Date: 1996/12/11
Message-ID: <32AEB9F2.36B9@interpath.com>#1/1
references: <58kmi5$ajf@news2.cais.com>
to: MCC <duffy@cais.cais.com>
content-type: text/plain; charset=us-ascii
organization: Interpath
mime-version: 1.0
newsgroups: comp.databases.oracle.tools
x-mailer: Mozilla 2.02 (X11; I; HP-UX A.09.05 9000/715)



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@interpath.com