RE: search fields
- From: "David Kurtz" <info@xxxxxxxxxxxxxxx>
- To: <Dan.Fink@xxxxxxxxxx>, <jacintakean@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 28 May 2005 02:32:38 +0100
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
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
