格式化为小数
1
2
3
4
select
to_char(round(0.2, 3),'fm99999999990.000')
from
dual;
格式化为百分比
1
2
3
4
select
to_char(round(0.2*100,2),'fm99999999990.00')||'%'
from
dual;
1
2
3
4
select
to_char(round(0.2, 3),'fm99999999990.000')
from
dual;
1
2
3
4
select
to_char(round(0.2*100,2),'fm99999999990.00')||'%'
from
dual;
A new version of content is available.