select
decode(trim(0.85),
0,
'0',
to_char(trim(0.85), 'fm9999999990.0000'))
from dual;
Oracle小数to_char时小数点前的0会丢失
最新推荐文章于 2023-01-31 14:37:52 发布
select
decode(trim(0.85),
0,
'0',
to_char(trim(0.85), 'fm9999999990.0000'))
from dual;