抢分呀，字串截取的问题！

Question

SQL> select translate('abc1242353','0123456789',' ') from dual;TRA
---
abc

Answer 1

在上面老兄的基础上,加点
select
translate('abc1242353','0123456789',' ') ch,
substr('abc1242353',length(translate('abc1242353','0123456789',' '))) num
from dual

Answer 2

不好意思上面少加了个一
select
translate('abc1242353','0123456789',' ') ch,
substr('abc1242353',length(translate('abc1242353','0123456789',' '))+1) num
from dual