Re: NVL2 in PL/SQl ?

Daniel Morgan wrote:
>
> Chris Weiss wrote:
>
> > If you must use it, you can use dynamic SQL, but this is a significant
> > performance hit. Depending on the data types involved, DECODE or SIGN may
> > do what you need.
> >
> > Good Luck!
> >
> > --
> >
> > ~~~~~~~~~~~~~~~~
> > Chris Weiss
> > mailto: chris_at_hpdbe.com
> > www.hpdbe.com
> > High Performance Database Engineering
> > ~~~~~~~~~~~~~~~~
> >
> > "R Chin" <rchin_at_panix.com> wrote in message
> > news:aajrcd$47n$1_at_reader1.panix.com...
> > >
> > > NVL2 can NOT be used in static SQL in PL/SQL, is this right ?
> > >
> > > thanks
> > >
> > > robert
> > >
> > >
>
> Native dynamic SQL is a "significant" performance hit?
>
> Daniel Morgan

You're basically up for parse (hard or soft) every time which can hurt in terms of concurrency. Of course doing a decode means a 'select from dual', so maybe just a if-then-else may be the best option

hth
connor

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

http://www.oracledba.co.uk

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