Re: search fields

select table_name from dba_Tab_columns
where table_name in ('   .)
and column_name is .....

----- Original Message ----- 
From: "Kean Jacinta" <jacintakean@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, May 27, 2005 2:33 PM
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: