方法一,使用to_char()
SQL> select to_char(.34, '0.99') from dual;
TO_CH
-----
0.12
SQL> select case when abs(mynumber) < 1 then
to_char(mynumber, '0.99') else to_char(mynumber) end mynumber
from dual;
方法二:使用column format
具体可以看column 的用法:
http://www.adp-gmbh.ch/ora/sqlplus/column.html#format