Oracle字符串函数
select upper('yes') from dual;
select lower('NO') from dual;
SELECT concat('json','code') from dual;
select 'son'||'as1'||'delete' from dual;
SELECT chr(97)||chr(65)||chr(84) "dog" from dual;
select initcap('hello world') "Capitals" from dual;
select lpad('java',8,'*') from dual;
select rpad('java','8','*') "RPAD" from dual;
SELECT RTRIM('xyxXxyLAST WORD ',' ') "RTRIM example" FROM DUAL;
select rtrim('xyxXxyLAST WORD','D') from dual;
select ltrim('xyxXxyLAST WORD','Xyx') from dual;
SELECT REPLACE('JACK and JUE','J','BL') "Changes" FROM DUAL;
SELECT length('hello') from dual;
select instr('hello','o') from dual;
select instr('CORPORATE FLOORJOR','OR',5,3) from dual;
SELECT SUBSTR('ABCDEFG',3,2) "Substring" FROM DUAL;
SELECT
REGEXP_REPLACE('500 Oracle Parkway, Redwood Shores, CA',
'( ){2,}', ' ') "REGEXP_REPLACE"
FROM DUAL;