Re: NULL values in arithmetic

From: Klaus Zeuch <KZeuch_at_nospamhotmail.com>
Date: 2000/08/02
Message-ID: <8m9skk$oa4$18$1@news.t-online.com>#1/1

Hi,

that's normal - nothing plus anything is nothing...

"Workaround": use the nvl-function to replace occurrences of NULL with 0, e.g.:
select (15+nvl(NULL,0)+8+4) from emp;

Klaus

"Matt Pryor" <matt_at_ddm-net.com> schrieb im Newsbeitrag news:965243472.345182_at_lnd-hst-1.atlas.net.uk...
> Hi there,
>
> I'd expect the following query:
>
> select (15+NULL+8+4) from emp;
>
> to ignore the NULL and return the sum of 15,8 and 4. Instead it returns
> NULL.
>
> Is this normal? Why is it? Is there a workaround?
>
> Thanks in advance for any help,
>
> Matt
>
>
Received on Wed Aug 02 2000 - 00:00:00 CDT