Re: Simple NVL question

From: Business <ihatespam_at_nomail.com>
Date: Fri, 5 Jan 2001 16:31:39 -0500
Message-ID: <935dsd$udv$1@msunews.cl.msu.edu>

sum(nvl(field2,0))

The NVL shouldn't be necessary. A column with nulls adds nothing to the results.

"Glen A. Stromquist" <glenstr_at_my-deja.com> wrote in message news:935d3r$7iq$1_at_nnrp1.deja.com...
> It must be friday, my brain has locked up already...
>
> I want to do a query on a table that sums a column that may have null
> values. So I type in:
>
> select field1, nvl(sum(field2),0)
> from table
> group by field1
>
> ERROR:
> ORA-24347: Warning of a NULL column in an aggregate function
>
> Interestingly enough, the same query without the NVL function returns
> results when I run it in a TOAD window.
>
> I'm missing something obvious here... what is it?
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Jan 05 2001 - 15:31:39 CST