-- 1. 最直接
select (0.123 * 100) || '%' as rate from dual;
-- 2. 可精确小数点位数
select round(10/100,2)*100 || '%' as rate from dual;
转载于:https://my.oschina.net/taadis/blog/1810871
-- 1. 最直接
select (0.123 * 100) || '%' as rate from dual;
-- 2. 可精确小数点位数
select round(10/100,2)*100 || '%' as rate from dual;
转载于:https://my.oschina.net/taadis/blog/1810871