RE: Consistent Null Handling
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Sep 2004 08:10:31 -0400
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@xxxxxxxxxxxxxxxxx]
Sent: Thursday, September 02, 2004 2:43 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
