ORA-01476: divisor is equal to zero

select 

 

'&field1' field1,

'&field2' field2,

case 

    when '&field1' = 0 then 0

    when '&field1' != 0 then (('&field1'/'&field2')*100) 

end zero1_,

decode('&field2',0,0,(('&field1'/'&field2')*100)) zero2_,

decode('&field2',0,null,(('&field1'/'&field2')*100)) zero3_ 

from dual