RE: Consistent Null Handling

Ian,
it better be true for all those implementations -- 
because this is what the ANSI/ISO standard is telling us to do ;-)
please, invite me to teach my favorite one-day seminar on this topic ...
 
Kind regards,
Lex.
 
-------------------------------
visit http://www.naturaljoin.nl 
-------------------------------
skype me <callto://lexdehaan> 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of MacGregor, Ian A.
Sent: Thursday, September 02, 2004 19:43
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 - http://freelists.org/archives/oracle-l/09-2004


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

Other related posts: