Re: [Q]script needed!

From: Dave Young <dyoung_at_cha.ab.ca>
Date: 1996/12/11
Message-ID: <58l9sa$scr@news1.edmonton.istar.net>#1/1

In article <58kjkb$5tn_at_news2.cais.com>, duffy_at_cais.cais.com says...
>
>Hi Oracle Gurus,
>

Hardly a Guru but try the all_tab_columns table it has both column name and table name. (Select table_name from all_tab_columns where column_name like ..)

Good Luck..........dy

>
> 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
Received on Wed Dec 11 1996 - 00:00:00 CST