Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NVL2 in PL/SQl ?

Re: NVL2 in PL/SQl ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 30 Apr 2002 19:17:35 +0100
Message-ID: <3CCEDFBF.5948@yahoo.com>


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..."
Received on Tue Apr 30 2002 - 13:17:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US