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

Home -> Community -> Usenet -> c.d.o.tools -> Re: NULL values in arithmetic

Re: NULL values in arithmetic

From: Patrick Diks <patrick.diks_at_capgemini.nl>
Date: 2000/08/03
Message-ID: <39893E5D.73CCBB60@capgemini.nl>#1/1

Hi,

Actually it's anything, not nothing.
something + anything = anything.

regards,

Patrick Diks

Matt Pryor wrote:

> Great, thanks I'll give that a try.
>
> Still don't understand the logic behind "nothing plus something = nothing"
> though!
>
> Klaus Zeuch <KZeuch_at_nospamhotmail.com> wrote in message
> news:8m9skk$oa4$18$1_at_news.t-online.com...
> > 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 Thu Aug 03 2000 - 00:00:00 CDT

Original text of this message

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