ORACLE SQL格式化小数点

ORACLE SQL格式化小数点

select
CONCAT(TO_CHAR(0.00100,‘990.999’),‘%’) as a0 ,
CONCAT(TO_CHAR(1100,‘990.999’),‘%’) as a1 ,
CONCAT(TO_CHAR(0.236100,‘990.999’),‘%’) as a2 ,
CONCAT(TO_CHAR(0.0200100,‘990.999’),‘%’) as a3 ,
CONCAT(TO_CHAR(1.03100,‘990.999’),‘%’) as a4 ,
CONCAT(TO_CHAR(0.1100,‘990.999’),‘%’) as a5 ,
CONCAT(TO_CHAR(-0.05*100,‘990.999’),‘%’) as a6
from dual;