How can I treat NULL-Values as Zero

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