方法1:
select translate('y1231231uasdas1.123122','0123456789.'||'y1231231uasdas1.123122','0123456789.') from dual;
方法2:
REGEXP_REPLACE( '字段名', '[^0-9.]')
方法1:
select translate('y1231231uasdas1.123122','0123456789.'||'y1231231uasdas1.123122','0123456789.') from dual;
方法2:
REGEXP_REPLACE( '字段名', '[^0-9.]')