Consistent Null Handling

From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 2 Sep 2004 11:43:12 -0700

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 - http://freelists.org/archives/oracle-l/09-2004

Follow-Ups:

RE: Consistent Null Handling
From: Lex de Haan

Consistent Null Handling

Other related posts: