繁体
242582598
sql>selectcosh(20)fromdual;
29.sign
floor(2345.67)
19.ceil
log(2,1)log(2,4)
28.round和trunc
power(2,10)power(3,3)
返回一个n1除以n2的余数
ln(1)ln(2)ln(2.7182818)
---------
sql>selectmod(10,3),mod(3,3),mod(2,3)fromdual;
返回大于或等于给
数字的最小整数
取数字n的符号,大于0返回1,小于0返回-1,等于0返回0
照指定的
度
行舍
25.log(n1,n2)
ceil(3.1415927)
asin(0.5)
.78539816
14.trim(‘s‘from‘string‘)
--------------
17.asin
16.acos
1
31.sigh
------------------
4
sql>selectexp(2),exp(1)fromdual;
acos(-1)
22.exp
cosh(20)
返回n1的n2次方
atan(1)
2345
---------------------
------------
weather
sql>selectasin(0.5)fromdual;
sql>selectsin(20),sinh(20)fromdual;
100100
leading剪掉前面的字符
返回一个数字的对数值
---------------
返回一个数字的正弦值
----------------------------
本章尚未读完,请
击下一页继续阅读---->>>
返回一个数字e的n次方
---------
20.cos
21.cosh
---------------------------
------------------
返回一个数字的反正切值
给
反正弦的值
sql>selectln(1),ln(2),ln(2.7182818)fromdual;
102427
15.abs
mod(10,3)mod(3,3)mod(2,3)
30.sin
cos(-3.1415927)
------------------
--------
如果不指定,默认为空格符
---------
sql>selectabs(100),abs(-100)fromdual;
xm
sql>selectsin(1.57079)fromdual;
sql>selectatan(1)fromdual;
abs(100)abs(-100)
102
trailing剪掉后面的字符
-1
wether
27.power
18.atan
--
返回一个以n1为底n2的对数
weather‘);
0.69314718.99999999
sql>selectpower(2,10),power(3,3)fromdual;
02
sql>selectceil(3.1415927)fromdual;
round(55.5)round(-55.4)trunc(55.5)trunc(-55.5)
sql>selectcos(-3.1415927)fromdual;
----------------------------------------------
.52359878
26.mod(n1,n2)
返回一个数字反余弦值
-------------------------------
sql>selectacos(-1)fromdual;
返回双曲正弦的值
56-5555-55
sql>selectfloor(2345.67)fromdual;
返回一个给定数字的余弦
对给定的数字取整数
sql>selectlog(2,1),log(2,4)fromdual;
sin(20)sinh(20)
---------
exp(2)exp(1)
23.floor
7.38905612.7182818
sql>selectsign(123),sign(-100),sign(0)fromdual;
24.ln
sin(1.57079)
sign(123)sign(-100)sign(0)
1-10
---------------
返回指定值的绝对值
3.1415927
sql>selectround(55.5),round(-55.4),trunc(55.5),trunc(-55.5)fromdual;
给
反余弦的值