Conn hr/hrWith version 10, you can use Regexp_Replace as shown:
Select Translate(Phone_Number,
' !"#$%&''()*+,-./:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~' ,' ') As
Digits,
Phone_Number
From Employees;
Select Regexp_Replace('abcABC123^&*','[^[:alnum:]]')
From Dual
SQL> /
REGEXP_RE
---------
abcABC123
No comments:
Post a Comment