----------------------------------------------- set linesize 75 col owner form a25 col table_name form a30 SELECT owner, table_name FROM dba_tab_columns WHERE lower(column_name) = 'medicode' ORDER BY owner, table_name; clear col -------------------------------------------- cut and paste above command at sqlplus execute above command will give you list of table with medicode column ----- Original Message ----- From: "Kean Jacinta" <jacintakean@xxxxxxxxx> To: <all_about_oracle@xxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> Sent: Friday, May 27, 2005 3:52 PM Subject: Re: search fields > > What is this (' .)? > > where table_name in (' .) > > > --- Oracle <all_about_oracle@xxxxxxxxxx> wrote: > > 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 > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l