oracle中substrb和instr函数用法

SQL> select substr('网易',1,2) from dual;

&jr3G0d"{1krx8U1u0SUBS
\I+qA,Q
ea.sy0----
VhS4u!t
BW0网易51Testing软件测试网$]2e+OW1e,F2YN

,J\&Z{7}mx~&\ I E0SQL> select substrb('网易',1,2) from dual;51Testing软件测试网'z-F2^ s s4V

)Kh;e9w)h&[v0SU51Testing软件测试网 K.^,CPF
--
N(Fx0I%?
O0网51Testing软件测试网:T_%_2ycaIt"I

09:54:56 SQL> select instr('网易zrsoft','z',1,1) from dual;

INSTR('网易ZRSOFT','Z',1,1)51Testing软件测试网^Z%J:Q#g,M
---------------------------
F.~as!P!y0oD;uH0351Testing软件测试网&c1H;\'v l

已用时间: 00: 00: 00.10
!nzTN5G?(R009:55:08 SQL> select instrb('网易zrsoft','z',1,1) from dual;51Testing软件测试网 s U%WsZo7Tx

c*{ixpeM~Y0INSTRB('网易ZRSOFT','Z',1,1)
Hz,~'X3O/E w@#P0----------------------------51Testing软件测试网#]&m6b-B|5s I
5

5e9rJSr2q"L0已用时间: 00: 00: 00.1051Testing软件测试网\c!\nT?ID
g
09:55:15 SQL> select instr('网易zrsoft','z',4,1) from dual;

+`0K
Gg$@u%B gE9cr0INSTR('网易ZRSOFT','Z',4,1)
,l${)a*b~7IfV0---------------------------
,_%M8c} E2aqZ7`N0051Testing软件测试网 G'~-L6r3Sa*I{

已用时间: 00: 00: 00.10
Kz{l4cq009:55:25 SQL> select instrb('网易zrsoft','z',4,1) from dual;51Testing软件测试网%v0wUTA8i9[6Qt3}:f

INSTRB('网易ZRSOFT','Z',4,1)51Testing软件测试网$FG%xi'T#M+T2mj
----------------------------51Testing软件测试网C3v](W$@,iN
5