Re: Finding all tables with a particular field?
From: Svend Jensen <Svend.JensenSPAMKILL_at_secret.dk>
Date: Sat, 14 Oct 2006 15:04:21 +0200
Message-ID: <4530e056$0$837$edfadb0f_at_dread12.news.tele.dk>
Date: Sat, 14 Oct 2006 15:04:21 +0200
Message-ID: <4530e056$0$837$edfadb0f_at_dread12.news.tele.dk>
Fred Wilson wrote:
> Hello,
>
> How does one go about finding all the tables that have a particular
> field name? For example a field name "EVENT_CODE"
>
> I would like to find all the places in the database this is located.
> Ultimately I want to further find in that field the code "0214" and
> change it to "0200".
>
> Thank you,
> Fred
Check the views user/all/dba_tab_columns
Rgds
Svend Received on Sat Oct 14 2006 - 15:04:21 CEST