CREATE OR REPLACE FUNCTION to_percent
(a in number,b in number)
return varchar2
is
c varchar2(20);
begin
if(a=0 or b=0)
then
c:='0';
else
c:= trunc(a*100/b,2)||'%';
end if ;
return c;
end;
如1/1000,回返回“.1%”,但我想要的结果为“0.1%”
参考资料:http://hi.baidu.com/luodaijun/blog/item/b073d262d247d1dee6113a43.html