for example:
SQL> select substr('aef12234rgsdrf',
2 instr(translate('aef12234rgsdrf','0123456789',' '),' '),
3 instr(translate('aef12234rgsdrf','0123456789',' '),' ',-1)
4 -instr(translate('aef12234rgsdrf','0123456789',' '),' ')+1) from dual;SUBST
-----
12234SQL>
SQL> select substr('aef12234rgsdrf',
2 instr(translate('aef12234rgsdrf','0123456789',' '),' '),
3 instr(translate('aef12234rgsdrf','0123456789',' '),' ',-1)
4 -instr(translate('aef12234rgsdrf','0123456789',' '),' ')+1) from dual;SUBST
-----
12234SQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货