1:translate方法:
select translate('123abc123','0123456789'||'123abc123','0123456789') from dual;
2:正则匹配:
select regexp_replace('123abc123','[^0-9]') from dual;
1:translate方法:
select translate('123abc123','0123456789'||'123abc123','0123456789') from dual;
2:正则匹配:
select regexp_replace('123abc123','[^0-9]') from dual;
转载于:https://my.oschina.net/chenhao901007/blog/355698