字符函数-big.data.analytics.with.spark

上传:eventually5559 浏览: 7 推荐: 0 文件:pdf 大小:31.31MB 上传时间:2024-07-07 04:02:24 版权申诉
第四章单行函数4.1、字符函数Upper SELECT Upper ('abcde') FROM dual ; SELECT * FROM emp WHERE ename=UPPER('smith') ; Lower SELECT lower('ABCDE') FROM dual ; Initcap Select initcap(ename) from emp; Concat Select concat(„a‟,‟b‟) from dual; Select „a‟ || „b‟ from dual; Substr Select substr(„abcde‟,length(„abcde‟)-2) from dual; Select substr(„abcde‟,-3,3) from dual; Length Select length(ename) from emp; Replace Select replace(ename,‟a‟,‟A‟) from emp;
上传资源
用户评论