陳立(jonathan666) (14:33:28):

alibaba@OCNDB>select to_char((80/90)*100,'99990.99')||CHR(37) as x from dual;

X
----------
88.89%

葉正盛(yzsind) (14:34:25):

select trim(to_char(90.345,'99999990.99'))||'%' from dual

王濤(alivogts) (14:34:39):

select case
when substr(col,1,1)=0 then substr(col,2)
else col
end
from (select to_char(lpad(trunc((89.18/100)*100,2),5,0)) col from dual);

友好的顯示小數ORACLE

相關文章