search fields

hi ,

Just want to know , would it be possible to search all
tables that contains medicode. 

Giving an example: i have 15 tables .And only 9 tables
contains medicode. The field name medicode is d same
in all the 9 tables.

Is tat possible to query sql statement to show all
tables that contains medicode fields ?

If there are none , can you please suggest other ways
to obtain it ? 

Thank You

JK 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: