不然oracle吃掉小数点前的0的方法

利用to_char(num,'990.99') 的方法，取得小数点前的0

比如

select (round(o_linesum/od_linesum,4)*100||'%') as od_line_tpercent as od_line_percent  from od_linesum

1 50.01%
2 19.45%
3 07.91%
4 7.87%
5  .38%

修改为

select  to_char(round(o_linesum/od_linesum,4)*100,'990.99')||'%' as od_line_percent  from od_linesum

1 50.01%
2 19.45%
3 07.91%
4 7.87%
5 0.38%

即可保证小数点前的0不会被oracle吃掉