ORACLE学习笔记系列(12)数字函数
数字函数
ABS :求绝对值函数,如:abs(-5) = 5
SQRT :求平方根函数,如:sqrt(2) = 1.41421356
POWER :求幂函数,如:power(2,3) = 8
COS :求余弦三角函数,如:cos(3.14159) = -1
ACOS :求反余弦三角函数,如:ACOS(0.3) = 1.26610367
MOD :求除法余数,如:mod(1600, 300) = 100
CEIL :求大于等于某数的最小整数,如:ceil(2.35) = 3
FLOOR :求小于等于某数的最大整数,如:floor(2.35) = 2
ROUND :按指定精度对十进制数四舍五入,如:
round(45.923, 1),结果,45.9
round(45.923, 0),结果,46
round(45.923, -1),结果,50
TRUNC :按指定精度截断十进制数,如:
trunc(45.923, 1) = 45.9
trunc(45.923) = 45
trunc(45.923, -1) = 40
SIGN :用于检测数字的正负。
如果数字小于0,则返回值为-1;
如果数字等于0,则返回值为0;
如果数字大于0,则返回值为1;
如:
SIGN(0.3) = 1
SIGN(-0.3) = -1
SIGN(0) = 0
SIGN('3') = 1