RE: Consistent Null Handling
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: lex.de.haan@xxxxxxxxxxxxxx
- Date: Fri, 3 Sep 2004 06:13:57 -0700
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@xxxxxxxxxxxxxx>:
> 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@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
