oracle 数据小数显示

Question

select round(5*2.00,2) from dual;
显示结果 10
要显示这样的结果，10.00 怎么改一下

Answer 1

select trim(to_char(5*2.00,999999.99)) from dual;

Answer 2

select to_char(round(5*2.01,2),'FM99.00') from dual; 

Answer 3

select trim(to_char(5*2.00,999999.99)) from dual;
这样就可以了呀!

Answer 4

select trim(to_char(5*2.00,999999.99)) from dual;

Answer 5

select to_char(0.123,999.0099) from dual;
 .123 --空格+.123
select to_char(0.123,'FM999.0099') from dual;
.123 --.123 要得到0.123 呢？

Answer 6

select to_char(0.123,'FM990.0099') from dual; 

Answer 7

我知道了，
select to_char(0.123,'FM990.0099') from dual;