oracle中substrb和instr函数用法

SQL> select substr('网易',1,2) from dual;51Testing软件测试网"V/C/B5_c1k'p.P

7Xw:Cw#e*z@ p0SUBS51Testing软件测试网DO4|@%Wn
zQ,?W-h R
----
^:@"h.U2_U0网易

8|s+uTE/b'iO0SQL> select substrb('网易',1,2) from dual;51Testing软件测试网,p5MN[@|;w

SU
QY0o'N'pxt0--51Testing软件测试网TQ7Y+}S1c[:|m
网

09:54:56 SQL> select instr('网易zrsoft','z',1,1) from dual;51Testing软件测试网c6Ag7} h[$G VN

INSTR('网易ZRSOFT','Z',1,1)51Testing软件测试网 rT2u%e~7g#T5u3K
---------------------------51Testing软件测试网I$Xqhw8u^Y!@d
3

a@Y y"L\ABT0已用时间: 00: 00: 00.1051Testing软件测试网b8x G)]6O` @6{
09:55:08 SQL> select instrb('网易zrsoft','z',1,1) from dual;

t%D"YUnF P-T EI0INSTRB('网易ZRSOFT','Z',1,1)51Testing软件测试网9y|_)epl
----------------------------
y:OnNrJ-B05

a F's!jYi0已用时间: 00: 00: 00.10
CS^$OIE+A2\009:55:15 SQL> select instr('网易zrsoft','z',4,1) from dual;

bv(NXG0INSTR('网易ZRSOFT','Z',4,1)
Q?wZD0---------------------------
cY?r Ny0051Testing软件测试网4V%TZvC4z tE}

g}+DW-OD-A0已用时间: 00: 00: 00.1051Testing软件测试网xx;zGb
09:55:25 SQL> select instrb('网易zrsoft','z',4,1) from dual;51Testing软件测试网8Sqg'S9i

INSTRB('网易ZRSOFT','Z',4,1)51Testing软件测试网t {u#v:r2S\
----------------------------
H ^PU&L&_+v5G R05