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: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 30 Apr 2002 15:52:26 GMT
Message-ID: <3CCEBDB8.EEEDB0AC@exesolutions.com>


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 Received on Tue Apr 30 2002 - 10:52:26 CDT

Original text of this message

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