instr & substr & upper & initcap

11:28:56 sys@ baipx2>select instr('Allan MCEwen',' ') from dual;

INSTR('ALLANMCEWEN','')
-----------------------
                      6

Elapsed: 00:00:00.00
11:29:29 sys@ baipx2>select instr('Allan MCEwen',' ')+1 from dual;

INSTR('ALLANMCEWEN','')+1
-------------------------
                        7

Elapsed: 00:00:00.01
11:29:40 sys@ baipx2>select substr('Allan MCEwen', instr('Allan MCEwen',' ')+1) from dual;

SUBSTR('ALLA
------------
MCEwen

Elapsed: 00:00:00.00
11:30:27 sys@ baipx2>select upper(substr('Allan MCEwen', instr('Allan MCEwen',' ')+1)) from dual;

UPPER(SUBSTR
------------
MCEWEN

Elapsed: 00:00:00.00
11:36:16 sys@ baipx2>select initcap(substr('Allan MCEwen', instr('Allan MCEwen',' ')+1)) from dual;

INITCAP(SUBS
------------
Mcewen

Elapsed: 00:00:00.01
11:36:34 sys@ baipx2>

Oracle 常用字符函数