DECODE(TO_CHAR(MOD(a.percnt, 1)),
'0.00',
TO_CHAR(a.percnt * 100) || '%',
TO_CHAR(ROUND(a.percnt * 100, 2), '99990.00') || '%') percnt,
oracle中解决百分数
最新推荐文章于 2023-05-16 11:48:45 发布
DECODE(TO_CHAR(MOD(a.percnt, 1)),
'0.00',
TO_CHAR(a.percnt * 100) || '%',
TO_CHAR(ROUND(a.percnt * 100, 2), '99990.00') || '%') percnt,