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 -> Re: Sql Update query syntax to increment a column containing nulls

Re: Sql Update query syntax to increment a column containing nulls

From: Keith Jamieson <pdkj02_at_email.mot.com>
Date: Tue, 30 Mar 1999 13:04:06 +0100
Message-ID: <3700BDB6.39AF3916@email.mot.com>


 

Global Infolinks wrote:

 

There is a "Null to zero" function in Oracle Sql syntax.
 UPDATE MyTable SET Num = Nvl(Num,0) + 1;
 

  Received on Tue Mar 30 1999 - 06:04:06 CST

Original text of this message

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