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

Home -> Community -> Usenet -> c.d.o.server -> Re: nvl2() can not be used in a cursor?

Re: nvl2() can not be used in a cursor?

From: Anthony Hogan <ahogan-nospam-_at_iespana.es>
Date: Fri, 30 Aug 2002 14:16:12 +0100
Message-ID: <3D6F701C.3CE05A3D@iespana.es> 







Norman Dunbar wrote:


> 

> Jochen,

> 

> NVL2 is only available in SQL*Plus, not in PL/SQL yet :o(

> It is available in PL/SQL in 9i release 2. (9.2.0)

> 

> Cheers,

> Norman.

> 




Jochen,


I came up against this recently. The workaround was to use decode.



hth


Anthony Hogan
Received on Fri Aug 30 2002 - 08:16:12 CDT












Original text of this message













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