Re: Help! Script needed...
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/12/11
Message-ID: <58lq9j$pr0_at_newton.pacific.net.sg>#1/1
Date: 1996/12/11
Message-ID: <58lq9j$pr0_at_newton.pacific.net.sg>#1/1
duffy_at_cais.cais.com (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
Hi there,
Try the following script
select table_name
from user_tab_columns
where column_name = 'your column name'
Regards
N.Prabhakar Received on Wed Dec 11 1996 - 00:00:00 CET