RE: search fields

From: Dan Fink <Dan.Fink_at_hotsos.com>
Date: Fri, 27 May 2005 13:24:27 -0500
Message-ID: <7647600.1117218267514.JavaMail.root@hotsos01.hotsos.com>

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

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 - 14:29:30 CDT