數(shù)學(xué)函數(shù)
1）abs( ) :取絕對(duì)值
select abs(1.0),abs(-5.3) from dual;
image.png
2）round():四舍五入
select round(1.4999),round(1.5),round(-1.4568,2),round(-53451.4568,-2) from dual;
image.png
3） truncate():截?cái)?br> select truncate(1.4999,2),truncate(1.5,1), truncate(-1.4568,2),truncate(-53451.4568,-2) from dual;
image.png
4）ceil( ) :向上(后)取整
select ceil(1.0001),ceil(1.9), ceil(-221.9),ceil(-1.001) from dual;
image.png
5） floor() :向下（前）取整
select floor(1.0001), floor(1.9), floor(-221.9), floor(-1.001) from dual;
image.png
6）rand( ):隨機(jī)數(shù)
image.png
7）pi( ) :圓周率
image.png
8）mod( ):求余數(shù)
image.png
9）sqrt( ):算術(shù)平方根
select mod(8,3),sqrt(-4),sqrt(5) from dual;
image.png
10）sin( ) :正弦函數(shù)
cos( ) :余弦函數(shù)
tan( ) :正切函數(shù)
select sin(pi()/2),cos(pi()),tan(pi()/4);
image.png
