一、str: 100000-0-21240 select substr('100000-0-21240',instr('100000-0-21240','-0-')+3) from dual;
结果:21240
二、str: 20000-0-53
select substr('20000-0-53',instr('20000-0-53','-0-')+3) from dual;
结果:53
一、str: 100000-0-21240 select substr('100000-0-21240',instr('100000-0-21240','-0-')+3) from dual;
结果:21240
二、str: 20000-0-53
select substr('20000-0-53',instr('20000-0-53','-0-')+3) from dual;
结果:53