REGEXP_REPLACE正则过滤掉字母
SELECT
trim(REGEXP_REPLACE( ‘ASS还好’, ‘[^a-zA-Z]’, ‘’)) || ‘|’ || trim(REGEXP_REPLACE( ‘ASS还好’, ‘[a-zA-Z]’, ‘’ )) dd
FROM
dual;
REGEXP_REPLACE正则过滤掉字母
SELECT
trim(REGEXP_REPLACE( ‘ASS还好’, ‘[^a-zA-Z]’, ‘’)) || ‘|’ || trim(REGEXP_REPLACE( ‘ASS还好’, ‘[a-zA-Z]’, ‘’ )) dd
FROM
dual;