Re: search fields
- From: "Oracle" <all_about_oracle@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 27 May 2005 15:49:32 +0800
select table_name from dba_Tab_columns
where table_name in ('SDFSDFSDFSDF','SADFDSFDSF')
and lower(column_name) = 'medicode'
----- Original Message -----
From: "Kean Jacinta" <jacintakean@xxxxxxxxx>
To: <all_about_oracle@xxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, May 27, 2005 3:47 PM
Subject: Re: search fields
> Is the field name
>
> --- Oracle <all_about_oracle@xxxxxxxxxx> wrote:
> > what is medicode?
> > ----- 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!?
> Yahoo! Small Business - Try our new Resources site
> http://smallbusiness.yahoo.com/resources/
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
