CONCAT
select SUBSTR('HelloWorld',1,5) from dual;
SELECT CONCAT('Hello','World') from dual;
select SUBSTR('HelloWorld',1,5) from dual;
LENGTH
select length('HelloWorld') from dual;
INSTR 计算字符在字符串中首次出现的位置
select instr('Hello','l') from dual;
LPAD
select last_name,lpad(salary,10,' ') from employees;
RPAD
select last_name,rpad(salary,10,' ') from employees;
TRIM 字符移除
select trim('H' from 'HelloHHWorkdH') from dual;
REPLACE 字符替换(将字符串中所有包含的字符全部替换)
select replace('Hello Hery','H','W') from dual;
LOWER
select lower('HELLO') from dual;
UPPER
select upper('hello') from dual;
INITCAP 首字母转换成大写
select INITCAP('hello,world') from dual;