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 -> Replacing NVL

Replacing NVL

From: Mikko Lehtinen <mikko.lehtinen_at_add2phone.com>
Date: Wed, 12 Jun 2002 14:13:37 +0300
Message-ID: <ae7ad1$ndl$1@phys-news1.kolumbus.fi>


Hi all,

Does anyone know how the following SQL statement can be implemented without oracle specific nvl function?

Column pkX is a varchar2 and columnX is a number.

UPDATE tableX SET columnX = nvl(columnX, 0) + 1 WHERE pkX=?

Thanks

Mikko Received on Wed Jun 12 2002 - 06:13:37 CDT

Original text of this message

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