RE: search fields

On a point of pure pedantry that will return columns in views too.
If you just want tables then 

SELECT utc.table_name, utc.column_name
FROM    user_tab_columns utc, user_tables ut
WHERE utc.column_name = 'MEDICODE'
AND     utc.table_name = ut.table_name
/


regards
_________________________
David Kurtz


> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Dan Fink
> Sent: 27 May 2005 19:24
> To: jacintakean@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: 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
> 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: