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?

trpost (AT) gmail (DOT) com wrote:
NVL(caes_escalated, 0)
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org