search fields

  • From: Kean Jacinta <jacintakean@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 26 May 2005 23:33:51 -0700 (PDT)

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 
--
//www.freelists.org/webpage/oracle-l

Other related posts: