Oracle常用字符串函数

--(1)转换大写
select upper('HEllo') from dual;	--HELLO
--(2)转换为小写
select lower('HEllo') from dual;		--hello
--(3)首字母大写
select initcap('HEllo') from dual;	--Hello
--(4)截取字符串
select substr('Hello World',1,7) from dual;	--Hello W
--(5)字符串长度
select length('Hello World') from DUAL;	--11
--(6)定位子串
select instr('Hello World','l',-1,2) from dual;	--4
--(7)左侧填充
select lpad('Hello World',20,'55') from  dual;	--555555555Hello World
--(8)右侧填充
select rpad('Hello World',20,'55') from  dual;	--Hello World555555555
--(9)去除收尾空格
select trim('  HEllo ') from dual;	--HEllo
--(10)字符串替换
Select replace('Hello World','l','拉') from dual;	--He拉拉o Wor拉d
--(11)绝对值
select abs('-6.58') from dual;	--6.58
--(12)四舍五入
select round('44154646.154',-2) from dual;	--44154600
--(13)截断
select trunc('3.1415',2) from dual;	--3.14
--(14)向上取整
select ceil(3.14) from dual;	--4
--(15)向下取整
select floor(3.14) from dual;	--3
--(16)判断数值正负
select sign(1) from dual;	--1
--(17)三角函数
select sin(3.14) from dual;	--0.00159265291648695254054143632444326146
--(18)幂运算
select power(4,2) from dual;	--16
--(19)开平方根
select sqrt(16) from dual;	--4
--(20)取模
select mod(15,8) from dual;	--7
--(20)基数为e的幂运算exp(1)
select exp(4) from dual;	--54.59815003314423907811026120286087840308
--(21)对数运算
select log(4,16) from dual;	--2.00000000000000000000000000000000000001
--(22)自然对数运算
select ln(7) from dual;	--1.94591014905531330510535274344317972964
--(23)字符串连接
select concat('Hello','World') from dual;	--HelloWorld
--(24)ascii转换
select ascii('H') from dual;    --72
select chr(72) from dual;   --H
--(25)返回n的余弦值,n为弧长
select cos(5) from dual;