–绝对值:abs()
select abs(-2) value from dual; --(2)
–取整函数(大):ceil()
select ceil(-2.001) value from dual; --(-2)
–取整函数(小):floor()
select floor(-2.001) value from dual; --(-3)
–取整函数(截取):trunc()
select trunc(-2.001) value from dual; – (-2)
–四舍五入:round()
select round(1.234564,4) value from dual; --(1.2346)
–取平方:Power(m,n)
select power(4,2) value from dual; --(16)
–取平方根:SQRT()
select sqrt(16) value from dual; --(4)
–取随机数:dbms_random(minvalue,maxvalue)
select dbms_random.value() from dual; (默认是0到1之间)
select dbms_random.value(2,4) value from dual; (2-4之间随机数)
–取符号:Sign()
select sign(-3) value from dual; --(-1)
select sign(3) value from dual; --(1)
–取集合的最大值:greatest(value)
select greatest(-1,3,5,7,9) value from dual; --(9)
–取集合的最小值:least(value)
select least(-1,3,5,7,9) value from dual; --(-1)
–处理Null值:nvl(空值,代替值)
select nvl(null,10) value from dual; --(10)
select nvl(score,10) score from student;