RE: search fields
- From: "Dan Fink" <Dan.Fink@xxxxxxxxxx>
- To: jacintakean@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 27 May 2005 13:24:27 -0500
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
Other related posts:
