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