oracle中关于处理小数点位数的几个函数，取小数位数及转换为货币格式

1.四舍五入，取小数点后n位
select round(1.2345,3) from dual;
结果：1.235

2.保留两位小数，只舍
select  trunc(1.2345,2) from dual;
select  trunc(1.2399,2) from dual;
结果：1.23  1.23

3.取整数
返回大于或等于x的最大整数
select ceil(23.33) from dual;
结果： 24
select floor(23.33) from dual;
结果：23

返回舍入到小数点右边y位的x的值
select round(23.5) from dual;
select round(23.4) from dual;
select round(23.123,2) from dual;
select round(23.125,2) from dual;
结果:24 23 23.12   23.13

返回x截尾到y位小数的值
select trunc(23.33) from dual;
select trunc(23.53) from dual;
select trunc(23.1235,3) from dual;
select trunc(23.1235,2) from dual;
结果：23 23  23.123  23.12

4货币格式(以.00结尾
)

select decode(1000000,0,'0.00',trim(to_char(1000000,'99,999,999,999,999.99')))  from  dual ;
select decode(1000000,0,'0.00',trim(to_char(1000000