RE: Consistent Null Handling

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 3 Sep 2004 08:10:31 -0400
Message-ID: <543DF856D23431489D4B8028C300FBAB08AC941C@exchsen0a1mb>

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

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

From: MacGregor, Ian A. [mailto:ian_at_slac.stanford.edu] Sent: Thursday, September 02, 2004 2:43 PM To: oracle-l_at_freelists.org
Subject: Consistent Null Handling

One of the posts on "Cure for Madness" brought up consistent null = handling which Oracle does not do. For instance, "Select Column1 + Column2 from TableA;" returns null if either or both = columns are null. However "Select sum(Column1) from table A" will = return a value if there are non-null values in the column. Is this true = for all SQL versions? =20

Ian MacGregor
Stanford Linear Accelerato Center
ian_at_SLAC.Sranford.edu
---

To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004
---

To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004 Received on Fri Sep 03 2004 - 07:06:09 CDT