oracle中substrb和instr函数用法
oracle中 substrb和instr函数用法
SQL> select substr('网易',1,2) from dual;
SUBS
----
网易SQL> select substrb('网易',1,2) from dual;
SU
--
网09:54:56 SQL> select instr('网易zrsoft','z',1,1) from dual;
INSTR('网易ZRSOFT','Z',1,1)
---------------------------
3已用时间: 00: 00: 00.10
09:55:08 SQL> select instrb('网易zrsoft','z',1,1) from dual;INSTRB('网易ZRSOFT','Z',1,1)
----------------------------
5已用时间: 00: 00: 00.10
09:55:15 SQL> select instr('网易zrsoft','z',4,1) from dual;INSTR('网易ZRSOFT','Z',4,1)
---------------------------
0已用时间: 00: 00: 00.10
09:55:25 SQL> select instrb('网易zrsoft','z',4,1) from dual;INSTRB('网易ZRSOFT','Z',4,1)
----------------------------
5