select table_name from dba_Tab_columns where table_name in (' .) and column_name is ..... ----- Original Message ----- From: "Kean Jacinta" <jacintakean@xxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> 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 > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l