弱弱的问一句 oracle 如何将数字转换成百分比！

Question

如题：0.1245 TO 12%
      0.3478 TO 35%第三位有效数字四舍五入。

Answer 1

select round(0.12345*100,1)||'%' from dual;

Answer 2

select round(0.12345*100,1)||'%' from dual;

Answer 3

round 用来四舍五入，然后再||%

Answer 4

  select to_char(round(0.12345*100,1))||'%' from dual;

Answer 5

select round(0.1245*100,2)||'%' from dual