入门基础:认识OracleSQL内置函数(5)

文章作者 100test 发表时间 2007:03:14 13:56:04
来源 100Test.Com百考试题网

15.abs
返回指定值的绝对值
sql> 0select abs(100),abs(-100) from dual.
abs(100) abs(-100)
--------- ---------
100 100
16.acos
给出反余弦的值
sql> 0select acos(-1) from dual.
acos(-1)
---------
3.1415927
17.asin
给出反正弦的值
sql> 0select asin(0.5) from dual.
asin(0.5)
---------
.52359878
18.atan
返回一个数字的反正切值
sql> 0select atan(1) from dual.
atan(1)
---------
.78539816