substr用法:
select substr('aaabbbcccddd',3,6) from dual;
结果:abbbcc
instr用法:
select instr('yy2016_02_23','_',1,1) from dual;
结果:7
substr用法:
select substr('aaabbbcccddd',3,6) from dual;
结果:abbbcc
instr用法:
select instr('yy2016_02_23','_',1,1) from dual;
结果:7