Replace null in zeros
525948Aug 11 2006 — edited Aug 12 2006Friends i need to replace 0 in the bonus is null,for that i write the block like this
na number(12,2);
begin
select sal/bonus into na from v;
exception
when zero_divide then
insert into v (bonus) select decode(bonus,0,null) from v;
commit;
when others then
rollback;
end;
But my out put is like this
BONUS
------ ---
12
15
0 --where is null
12
0 --where is null here
Thank q all