SELECT DECODE ( LENGTH ('100.02')
- DECODE (INSTR (TO_CHAR ('100.02'), '.'),
0, LENGTH ('100.02'),
INSTR (TO_CHAR ('100.02'), '.')
),
1, CONCAT ('100.02', '0'),
0, CONCAT ('100.02', '.00'),'100.02'
)
FROM DUAL;
如何实现小数点后面数据的追加零
最新推荐文章于 2023-12-27 20:15:05 发布