日期:2014-05-17 浏览次数:20917 次
select to_number (Translate('a123','1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ','1234567890')) from dual
------解决方案--------------------
select to_number( REGEXP_REPLACE('a123ch','[a-zA-Z/:.]','') ) from table;