| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Consistent Null Handling
Lex,
I remember this being a problem back in the Oracle 6 days. My recollection is that any function running against a column that contained a null would prevent the function from returning anything except null.
Can't prove it anymore, but it really doesn't matter. It works the way it works now.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl]
Sent: Friday, September 03, 2004 9:09 AM
To: thomas.mercadante_at_labor.state.ny.us; oracle-l_at_freelists.org
Subject: 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:
Kind regards,
Lex.
-----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
-- 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:24:56 CDT
 |
 |