Re: How can I treat NULL-Values as Zero

Look up the NVL function in the docs...It should do what you want...

"Nicolas Bronke" <newsgroup_at_trinity.de> wrote:

>Is it possible to define how Oracle treats Null-Values?
>My problem if I make e.g. a summarize in a trigger like
>
>:new:field:=:new.f1+:new.f2;
>
>The result will be NULL if either F1 or F2 is NULL.
>
>Sometimes I would prefer to receive ZERO. With two fields it is no problem
>for checking null-values but sometimes the formula is more complecate.
>
>Tjanks for any hint.
>
>regards
>Nicolas
>
Received on Mon Jul 31 2000 - 00:00:00 CDT