102427

---------

floor(2345.67)

sql>selectexp(2),exp(1)fromdual;

照指定的度行舍

---------

242582598

本章尚未读完,请击下一页继续阅读---->>>

sql>selectmod(10,3),mod(3,3),mod(2,3)fromdual;

sql>selectsign(123),sign(-100),sign(0)fromdual;

sql>selectatan(1)fromdual;

02

sql>selectceil(3.1415927)fromdual;

atan(1)

leading剪掉前面的字符

sql>selectasin(0.5)fromdual;

102

返回一个数字的对数值

给反余弦的值

21.cosh

20.cos

14.trim(‘s‘from‘string‘)

---------------

sql>selectln(1),ln(2),ln(2.7182818)fromdual;

25.log(n1,n2)

weather‘);

29.sign

ceil(3.1415927)

cos(-3.1415927)

取数字n的符号,大于0返回1,小于0返回-1,等于0返回0

------------------

abs(100)abs(-100)

23.floor

sql>selectpower(2,10),power(3,3)fromdual;

wether

返回一个数字的反正切值

mod(10,3)mod(3,3)mod(2,3)

acos(-1)

.52359878

返回指定值的绝对值

round(55.5)round(-55.4)trunc(55.5)trunc(-55.5)

sql>selectcosh(20)fromdual;

sql>selectfloor(2345.67)fromdual;

sql>selectacos(-1)fromdual;

sql>selectsin(1.57079)fromdual;

----------------------------

对给定的数字取整数

2345

sign(123)sign(-100)sign(0)

sql>selectabs(100),abs(-100)fromdual;

28.round和trunc

---------------------

100100

power(2,10)power(3,3)

返回一个n1除以n2的余数

------------------

------------

19.ceil

log(2,1)log(2,4)

.78539816

---------

3.1415927

26.mod(n1,n2)

---------------------------

27.power

sql>selectround(55.5),round(-55.4),trunc(55.5),trunc(-55.5)fromdual;

--------

----------------------------------------------

给反正弦的值

7.38905612.7182818

trailing剪掉后面的字符

4

如果不指定,默认为空格符

22.exp

asin(0.5)

1-10

1

30.sin

--

---------

24.ln

返回大于或等于给数字的最小整数

-1

18.atan

-------------------------------

exp(2)exp(1)

sql>selectcos(-3.1415927)fromdual;

17.asin

sin(20)sinh(20)

返回一个以n1为底n2的对数

ln(1)ln(2)ln(2.7182818)

cosh(20)

0.69314718.99999999

---------------

15.abs

--------------

返回一个数字e的n次方

返回一个给定数字的余弦

sin(1.57079)

weather

------------------

返回n1的n2次方

返回双曲正弦的值

返回一个数字的正弦值

sql>selectlog(2,1),log(2,4)fromdual;

返回一个数字反余弦值

xm

sql>selectsin(20),sinh(20)fromdual;

56-5555-55

31.sigh

16.acos