Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: question for the wise?
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 Received on Thu May 09 2002 - 17:07:42 CDT
![]() |
![]() |