小数点前零丢失

 

select

TO_CHAR(0.3678，'FM9999.99')||'%' AS A,

TO_CHAR(0.3678，'FM9990.9')||'%' AS B,

TO_CHAR(0.3678，'9990.0')||'%' AS C,

TO_CHAR(0.3678，'FM9990.09')||'%' AS D,

TO_CHAR(0.3678，'FM9990.009')||'%' AS E,

TO_CHAR(0.3678，'FM000.00000')||'%' AS F

from dual;

A         B        C        D         E          F

--------- -------- -------- --------- ---------- -----------

.37%      0.4%         0.4% 0.37%     0.368%     000.36780%