Oracle:数值函数

来源：互联网发布：淘宝怎么开店充话费编辑：程序博客网时间：2024/05/24 05:42

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

阅读全文

0 0