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

This message: [ Message body ]
Next message: ahasanas_at_my-dejanews.com: "Re: Anybody got Oracle's ODBC driver working in Win95?"
Previous message: ahasanas_at_my-dejanews.com: "Re: Help - Oracle Platforms"
In reply to: Global Infolinks: "Sql Update query syntax to increment a column containing nulls"

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