Kent's Blog

統計數值計算常用

自己跑一跑就知道效果

select to_char(9876/10000) from dual
union all
select to_char(round(9876/10000,2)) from dual
union all
select to_char(round(9876/10000,2)) from dual
union all
select to_char(round(9876/10000,2),990.999) from dual
union all
select trim(to_char(round(9876/10000,2),990.999)) from dual
union all
select to_char(
                (round(9876/10000,2))*100,
       990.999)||'%'
from dual
union all
select trim(to_char(
                (round(9876/10000,2))*100,
       990.999)||'%')

from dual