오라클 정규식 REPLACE 특수문자 제거

SELECT TRIM(REGEXP_REPLACE(‘(010)-1!@1 1&%1-22**2 2’, ‘[^[:alnum:]+]’, ”))
FROM DUAL;

Leave a Reply

Your email address will not be published.