RE: Consistent Null Handling

Hi Tom,
I am not sure, but I don't think this has been any different in earlier
releases of Oracle.
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))
- nvl(sum(x),0)

Kind regards,
Lex.

-------------------------------
visit http://www.naturaljoin.nl
-------------------------------
skype me <callto://lexdehaan>

-----Original Message-----

Ian,

This is true for 817 & 9204.  I could have sworn that you needed to do the
following to get it to work:

Select sum(nvl(col1,0)) from table

Maybe in a prior release (like 6.x) the above was required.

Tom Mercadante
Oracle Certified Professional


-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-vcard
-- File: Lex de Haan.vcf


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

Other related posts: