nvl2() can not be used in a cursor?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 30 Aug 2002 13:34:11 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70294B4C2@lnewton.leeds.lfs.co.uk>

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.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Fri Aug 30 2002 - 07:34:11 CDT

This message: [ Message body ]
Next message: Ronald: "Re: ORA-04030: out of process memory when trying to allocate 123952 bytes(callheap,temporary memory)"
Previous message: Norman Dunbar: "Cached blocks and performance"
In reply to: Jochen Van den Bossche: "nvl2() can not be used in a cursor?"
Next in thread: Anthony Hogan: "Re: nvl2() can not be used in a cursor?"
Reply: Anthony Hogan: "Re: nvl2() can not be used in a cursor?"
Reply: Vladimir M. Zakharychev: "Re: nvl2() can not be used in a cursor?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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