Re: Find all tables with a particular field

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

All relational databases have data dictionaries. Are you familiar with the concept? If not then I suggest the following query:

SELECT view_name
FROM all_views
WHERE (view_name LIKE 'USER%' OR view_name LIKE 'ALL%') ORDER BY 1; The one you are looking for is: xxx_tab_columns.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group