Sum function returning a null?
655717Aug 20 2009 — edited Aug 21 2009I was wondering if it was possible to sum the values in a colum with one of the values being a null and actually return an integer.
Oracle: 10g
I've tried using the sum function and it returns a null value.
Eg...
Total
--------
1
2
0
2
(null here)
2
(null here)
2
0
1
1
Is there a function that will allow me to return 11 instead of a null value?