Oracle:数值函数

1.ABS()
ABS(x)：得到x的绝对值

select ABS(-56) from dual;


ABS(-56)
-------
56

2.CEIL()
CEIL(x)：获得大于或等于x的最小整数

select CEIL(5.8) from dual;

CEIL(5.8)
---------
6

3.FLOOR()

select CEIL(5.8) from dual;

CEIL(5.8)
---------
5

4.GREATEST()

select GREATEST(3,4,1) from dual;
GREATEST(3,4,1)
---------------
4

5.LEAST()

select LEAST(3,4,1) from dual;
GREATEST(3,4,1)
---------------
1

6.POWER()

select POWER(2,1),POWER(2,3) from dual;

POWER(2,1) POWER(2,3)
----------------------
2 8

7.ROUND()

select ROUND(5.75), ROUND(5.75,1),ROUND(5.75,-1) from dual;

ROUND(5.75) ROUND(5.75,1) ROUND(5.75,-1)
-----------------------------------------------
         6           5.8              10

8.SIGN()

select SIGN(-10),SIGN(0),SIGN(9) from dual;

SIGN(-10) SIGN(0) SIGN(9)
-----------------------------
     -1        0        1

9.SQRT:平方根

select SQRT(25) from dual;
SQRT(25)
-------
5

10.TRUNC

select TRUNC(5.75) from dual;

TRUNC(5.75)
----------
5