ORACLE数字的处理

1.round

功能：四舍五入函数

如：select round(1.23456789,2) from dual;

?

2.trunc

功能：截取函数

如：select trunc(1.23456789,2) from dual;

?

3.金额转换函数

select? to_char(round(10000 / 100.00, 2), 'FM9999999999999999.00') as amount from dual