Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NVL2 in PL/SQl ?
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