Re: question for the wise?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 10 May 2002 11:53:11 -0700
Message-ID: <a8aed4.0205101053.45fe8c75@posting.google.com>

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CDAF323.83D148D5_at_exesolutions.com>...
> FC wrote:
>
> > >
> > > Factor this one into the mixture:
> > >
> > > SELECT a,b,c
> > > FROM my_tble
> > > WHERE d = (
> > > SELECT 'XYZ'
> > > FROM dual);
> > >
> > > It's always been one of my favorites.
> > >
> > > Daniel Morgan
> > >
> >
> > Hehehe,
> > well, I can understand the humor, but, believe or not, it was a serious
> > question (at least from my standpoint!).
> >
> > Anyway I'll factor it tomorrow morning...
>
> I wasn't making a joke. It is often a lot faster than where d = 'XYZ'
>
> Daniel Morgan

Daniel,

Can u explain why select 'xyz' from dual will be better than saying ='xyz'.

Your comments pls.

Regards,
Ganesh R Received on Fri May 10 2002 - 13:53:11 CDT