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...

Take a look at SYS_CONTEXT

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."