Re: oracle sum display zero instead of NULL

trpost_at_gmail.com wrote:
> I have a simple query:
>
> SELECT SUM(cases_escalated) AS casesescalated FROM groupsummary WHERE
> report_date=TO_DATE('Sep 2007','MON YYYY') AND group_name = 'T1';
>
> The query works fine, except for when there is nothing to SUM and then
> I get returned NULL instead of 0.
>
> My question is how can I get the query to display 0 instead of
> 'blank'; I read something about using a join, but I don't see how
> joining would help me as right now this is the only table in my
> database. Would I somehow join against a query to DUAL?
>

By not summing NULLs: sum(nvl(cases_escalated,0)), or by decoding the NULL: nvl(sum(cases_escalated),0)

Which ever way you want it

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...