dbTalk Databases Forums  

Finding all tables with a particular field?

comp.databases.oracle comp.databases.oracle


Discuss Finding all tables with a particular field? in the comp.databases.oracle forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Fred Wilson
 
Posts: n/a

Default Finding all tables with a particular field? - 09-17-2006 , 09:30 PM






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

Reply With Quote
  #2  
Old   
Svend Jensen
 
Posts: n/a

Default Re: Finding all tables with a particular field? - 10-14-2006 , 09:04 AM






Fred Wilson wrote:
Quote:
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


Reply With Quote
  #3  
Old   
Paul
 
Posts: n/a

Default Re: Finding all tables with a particular field? - 10-14-2006 , 12:53 PM





Fred Wilson <faNOWilsonSPAM (AT) comcast (DOT) net> wrote:


Quote:
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".

Apart from Svend's advice, this group is dead. You should ask this
question on c.d.o.server.



Paul...


Quote:
Fred
--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.


Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.