SELECT DECODE(TRUNC(-.98),0,REPLACE(TO_CHAR(-.98), '.', '0.'),TO_CHAR(-.98))FROM DUAL; 转载于:https://www.cnblogs.com/bianshencho/archive/2009/09/27/1575072.html