RE: Consistent Null Handling

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 3 Sep 2004 06:13:57 -0700
Message-ID: <1094217237.41386e15234bd@webmail.hosting.telus.net>

I don't get that. Under what circumstances will sum(x) and sum(nvl(x,0)) give different results? I can see it for avg, but for sum?

Quoting Lex de Haan <lex.de.haan_at_naturaljoin.nl>:

> Note however that the following three Oracle expressions are (and always
> have been) *different*
> that is, they give *different* results under certain conditions:
>
> - sum(x)
> - sum(nvl(x,0))

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Received on Fri Sep 03 2004 - 08:09:47 CDT