select table_name from dba_Tab_columns
where table_name in (' .)
and column_name is .....
- Original Message -----
From: "Kean Jacinta" <jacintakean_at_yahoo.com>
To: <oracle-l_at_freelists.org>
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
Received on Fri May 27 2005 - 03:50:28 CDT
