select 1*0.09 as dd from dual
tst> select 1*0.09 from dual; 1*0.09 ---------- .09 tst> set numformat 099999.99 tst> / 1*0.09 ---------- 000000.09 tst> set numformat 999990.99 tst> / 1*0.09 ---------- 0.09