Oracle如何去除字符串中数字或字母

去除数字：

select replace(translate('abc1234ABC678aaad590AAA','0123456789',' '),' ','') from dual;

或使用正则表达式：

select regexp_replace ('abc1234ABC678aaad590AAA', '[0-9]+', '') as a from dual;

 

去除字符串中数字之外的所有字符：

select regexp_replace ('abc1234A，。/；‘、%#BC678aaad590AAA', '[^0-9]+', '') as a from dual;

去除字符串中的字母：

select regexp_replace ('abc1234A，。/；‘、%#BC678aaad590AAA', '([a-z]+|[A-Z])+', '') as a from dual;

 

特殊情况可根据自己理解去修改