select abs(-5) from dual;
select sqrt(2) from dual;
select power(2,3) from dual;
select cos(3.14159) from dual;
select mod(1600, 300) from dual;
select ceil(2.35) from dual;
select floor(2.35) from dual;
select round(45.923, 1) from dual;
select round(45.923,-1) from dual;
select trunc(45.923, 1) from dual;
select trunc(45.923, -1) from dual;
SELECT round(45.923,2), round(45.923,0), round(45.923, -1) FROM dual;
数值处理函数还有很多，比如：
SIN,SINH,COS,COSH,TAN,TANH, ACOS, ATAN, ATAN2和ASIN
我在这里就不一一介绍了，希望对大家有帮助。
最近在学习oracle，我会把我学习到的知识与大家分享。
转载请注明出处：http://www.cnblogs.com/yydcdut/p/3643796.html
原文：http://www.cnblogs.com/yydcdut/p/3643796.html