RE: search fields

SELECT table_name 
FROM user_tab_columns 
WHERE column_name = 'MEDICODE' 
/ 
  
  
----- Original Message ----- 
From: Kean Jacinta 
Sent: Fri May 27 00:34:02 MDT 2005 
To: oracle-l@xxxxxxxxxxxxx 
Subject: 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 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: