舍入

SQL> select round(11/3,2) from dual; ROUND(11/3,2) ------------- 3.67

取整

SQL> select trunc(11/3) from dual; TRUNC(11/3) ----------- 3

取余

SQL> select mod(11,3) from dual; MOD(11,3) ---------- 2

比值大的最小整数

SQL> select ceil(11/3) from dual; CEIL(11/3) ---------- 4 SQL> select ceil(-1.2) from dual; CEIL(-1.2) ---------- -1

比值小的最大整数

SQL> select floor(11/3) from dual; FLOOR(11/3) ----------- 3 SQL> select floor(-1.2) from dual; FLOOR(-1.2) ----------- -2