Re: Replacing NVL

From: LokalST <stbest001_at_hotmail.com>
Date: Thu, 13 Jun 2002 11:05:53 +0200
Message-ID: <ae9nig$gar$1@sunce.iskon.hr>

"Mikko Lehtinen" <mikko.lehtinen_at_add2phone.com> wrote in message news:ae7ad1$ndl$1_at_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=?

UPDATE tableX SET columnX = Decode(columnX,null,0,columnX) WHERE pkX = ? Hope this help
Mladen Received on Thu Jun 13 2002 - 04:05:53 CDT