nvl returns strange value

Hi all,

Lat us assume that a table named a_table is empty.

Is there anybody who knows why the script:

set null 0

column c57 new_value av_sum_c57

select sum(nvl(t3101_expired,0)) c57
from

        a_table
/

prompt TEST: &av_sum_c57

returns the following value

TEST: -~ But after small correction:

set null 0

column c57 new_value av_sum_c57

select nvl(sum(nvl(t3101_expired,0)),0) c57 from

        a_table
/

prompt TEST: &av_sum_c57

returns correctly:

TEST: 0 Is that a bug?

I will appreciate your help. Received on Tue Nov 14 2006 - 06:30:52 CST