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: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Tue, 20 Apr 1999 10:06:58 +0100
Message-ID: <371C43B2.C182F8EA@capgemini.co.uk>


You could write your own function. Not the best solution but at least you have control.

Aaron Ogren wrote:

> Hans NesbÝ wrote:
> >
> > Use NVL - NULL-Value Substitute.
> > The format is:
> > NVL(value, substitute)
> > If value is NULL, this function is equal to substitute
>
> Actually, I don't want to use NVL because 1+NULL=1 works
> under SQL*Server; SQL*Server does not know NVL and I
> don't want to add Oracle-specific code...Are there any
> other methods?
>
> Thanks,
> Aaron
>
> > >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 Tue Apr 20 1999 - 04:06:58 CDT

Original text of this message

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