Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: adding 1 to NULL = 1?
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 Mon Apr 19 1999 - 14:54:29 CDT