Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: adding 1 to NULL = 1?

Re: adding 1 to NULL = 1?

From: Hans Nesbø <hans.nesboe_at_selmer.no>
Date: Mon, 19 Apr 1999 21:27:50 +0200
Message-ID: <371b83fa.0@d2o201.telia.com>


Use NVL - NULL-Value Substitute.
The format is:
NVL(value, substitute)
If value is NULL, this function is equal to substitute

Aaron Ogren skrev i meldingen <371B7306.5AB2DE9A_at_lucent.com>...
>Using Oracle 8.0.5 for NT: Is there a way to change the
>Oracle handling of NULL number columns so that adding 1
>to a NULL value will set the value to 1 via initialization
>parameter or other methods, besides using the NVL function?
Received on Mon Apr 19 1999 - 14:27:50 CDT

Original text of this message

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