- 1、本文档共87页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
PLSQL常用函数【DOC精选】
PL/SQL函數
2008-01-18 10:56
--【字符串函数】--字符串截取substr(字段名,起始点,个数)select Name,substr(Name,2,4),substr(Name,0,3),substr(Name,-2,3),substr(Name,-2,1) from t1;
--字符串从前面取三个(0开始)select Name,substr(Name,0,3) from t1;--字符串从后面取三个select Name,substr(Name,-3,3),length(Name) 串 from t1;
SELECT ASCII(A),ASCII(B) from dual;
select CHR(100),CHR(80) from dual;
select CONCAT(CHR(65),CONCAT(CHR(67),CHR(98))) from dual;
select CHR(65)||CHR(66)||CHR(76) from dual;
--将每个。select INITCAP(substr,abc,substring) from dual;--返回i在MISSISSIPPI中第3次出select INSTR(Mississippi,i,5,3) from dual;select INSTR(Mississippi,i,-2,3) from dual;--返回的是字select INSTRB(Mississippi,i,5,3) from dual;select INSTRB(Mississippi,i,-2,3) from dual;--长度select length(WHO ARE YOU) from dual;select nvl(null,空) from dual;--小写select lower(WHo are You) from dual;--LPAD左select LPAD(DFSDf................,9,WHO) from dual;select LPAD(DFSD,9,WHO) from dual;select LPAD(DFSD,9,) from dual;select LPAD(DFSD,length(DFSD)+length(WHO......),WHO......) from dual;--把最左select ltrim(Mississippi,Mis) from dual;select ltrim(Mississippi,miD) from dual;--RPAD右select RPAD(DFSDf................,9,WHO) from dual;select RPAD(DFSD,9,WHO) from dual;select RPAD(DFSD,9,) from dual;select RPAD(DFSD,length(DFSD)+length(WHO......),WHO......) from dual;--把最右select Rtrim(Mississippi,Mis) from dual;select Rtrim(Mississippi,miD) from dual;--替select REPLACE(uptown,up,down) from dual;--substr和substrbselect SUBSTR(Message,1,4) from dual;select SUBSTR(ABCDEFG,5) from dual;select substrb(国,5) from dual;select substrb(国,2) from dual;select substrb(国,4,8) from dual;select substrb(国,3,8) from dual;--发音select SOUNDEX(dawes) Dawes,SOUNDEX(daws) Daws, SOUNDEX(dawson) from dual;--translateselect TRANSLATE(ABCDefghijklmn,eg,替代) test from dual;
select TRIM( Space padded?? 0..o0.. ) trim from dual;
select UPPER(abDCCfasdfsdafasdf) from dual;
--【数学函数】所有函数都有数字参数并返回数字值。所有三角函数的操作数和值都是弧度而不是角度,--oracle没有提供内建的弧度和角度的select abs(-10.234) from d
您可能关注的文档
- Photoshop制作对称双向彩虹流光字【DOC精选】.doc
- Photoshop图层遮罩应用详解【DOC精选】.doc
- photoshop中文教程(免费)【DOC精选】.doc
- Photoshop制作温馨的照片拼图效果【DOC精选】.doc
- photoshop基础教程-修复画笔、修补、图章工具【DOC精选】.doc
- photoshop技巧【DOC精选】.doc
- PHOTOSHOP实例--钟表【DOC精选】.doc
- PET套题分析【DOC精选】.docx
- Photoshop抽线特效滤镜Alpha Strip【DOC精选】.doc
- Photoshop实例教程创建金属光泽图标【DOC精选】.doc
文档评论(0)