select TO_CHAR(0.52,'fm9999999990.00') from dual 输出:.52
select TO_CHAR(0.52,'fm9999999990.00') from dual 输出:0.52
fm为数据填充模式
具体用法:http://www.cnblogs.com/reborter/archive/2008/11/28/1343195.html
select TO_CHAR(0.52,'fm9999999990.00') from dual 输出:.52
select TO_CHAR(0.52,'fm9999999990.00') from dual 输出:0.52
fm为数据填充模式
具体用法:http://www.cnblogs.com/reborter/archive/2008/11/28/1343195.html