replace跟translate

replace和translate

replace('123123tech', '123');would return 'tech'translate('1tech23', '123', '456');would return '4tech56'translate('222tech', '2ec', '3it');would return '333tith'

:: extact one to on e matching of character like 'a' or '1'
?? replace character is needed
select translate('abc132fdsf','0123456789',' ') from dual;

?

?

-------

abcfdsf

或按以下方式

SQL> select translate('abc132fdsf','#0123456789','#') from dual;

?

-------

abcfdsf

--提取字符串中的数字，字母都被过滤，如下：

?

SQL> select translate('abc132fdsf','abcdefghigklmnopqrstuvwxyz',' ') from dual;

?

?

----