Re: [Q]script needed!

From: John Cutright <john.cutright_at_alliedsignal.com>
Date: 1996/12/17
Message-ID: <596hrv$ftg@asbe05.phx1.aro.allied.com>#1/1

> duffy_at_cais.cais.com (MCC) writes:
> Hi Oracle Gurus,
>
>
> Does anybody have a script that will list all the tables that
> have the same column name. For a particular column name, I need
> to know what tables have it. I could DESCIBE every table..., but
> I'll appreciate any suggestion more.
>
>
>
> Thanks,
> Edith
>

>>>>
select table_name from user_tab_columns
where column_name='YOUR_COLUMN_NAME_HERE' Received on Tue Dec 17 1996 - 00:00:00 CST