use decode such as

decode(:filed_a, null, '0', :field_a)

however defaultif does what you want as well, you may need to use preserve blanks, defaultif sets non-numeric to NULL and numeric to 0 if the condition is satisfied

http://download-west.oracle.com/docs...06.htm#1007544