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

第四章单行函数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;