Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Replacing NVL
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