1、
select to_char(123456789.12345,'fm999999990.99') from dual;
如果fm后位数不足则会显示 ##
select to_char(123456789.12345,'fm990.99') from dual
2、
select to_char(123.00,'fm999990.99') from dual;
3、
select to_char(123.00,'fm999990.00') from dual;
1、
select to_char(123456789.12345,'fm999999990.99') from dual;
如果fm后位数不足则会显示 ##
select to_char(123456789.12345,'fm990.99') from dual
2、
select to_char(123.00,'fm999990.99') from dual;
3、
select to_char(123.00,'fm999990.00') from dual;