RE: search fields

From: David Kurtz <info_at_go-faster.co.uk>
Date: Sat, 28 May 2005 02:32:38 +0100
Message-ID: <CKEAJBMGFEOCDBFILPJDCEDKGEAA.info@go-faster.co.uk>

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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Dan Fink
> Sent: 27 May 2005 19:24
> To: jacintakean_at_yahoo.com; oracle-l_at_freelists.org
> 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_at_freelists.org
> 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

Received on Fri May 27 2005 - 21:36:07 CDT