oracle 四舍五入 取得的数值

SELECT ROUND( number, [ decimal_places ] ) FROM DUAL--说明：number :-- 将要处理的数值decimal_places :-- 四舍五入，小数取几位,不填默认为0Sample :select round(987.456) from dual;           --  结果： 987select round(987.456, 0) from dual;        --  结果： 987 select round(987.456, 1) from dual;        --  结果： 987.5 select round(987.456, 2) from dual;        --  结果：987.46 select round(987.456, 3) from dual;        --  结果： 987.456 select round(-987.456, 2) from dual;       --  结果：-987.46