数值函数太多,简单介绍几种常见的。
1) round(m,n):四舍五入
SQL> select round(24.55,-1),round(24.55,0),round(24.55,1) from dual;
ROUND(24.55,-1) ROUND(24.55,0) ROUND(24.55,1)
--------------- -------------- --------------
20 25 24.6
- trunc(m,n):截断函数
若n=0或者省略,只取整数部分:
SQL> select trunc(1235.22) from dual;
TRUNC(1235.22)
--------------
1235
若n>0,则截断小数点右边n位:
SQL> select trunc(1235.22,1) from dual;
TRUNC(1235.22,1)
----------------
1235.2
若n<0,则截断小数点左边n位:
SQL> select trunc(1235.22,-1) from dual;
TRUNC(1235.22,-1)
-----------------
1230
3)mod(m,n)求取余数
SQL> select mod(15,3) from dual;
MOD(15,3)
----------
0
SQL> select mod(15,-2) from dual;
MOD(15,-2)
----------
1
4)abs() 求取余数
SQL> select abs(-19) from dual;
ABS(-19)
----------
19
5) POWER(X,Y)函数:X的Y次幂
SQL> select power(5,3) from dual;
POWER(5,3)
----------
125
------------------------------------------------------------------------------2020年04月12日