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
Received on Thu Sep 02 2004 - 19:01:05 CDT
