Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

All dashes (-) were dropped from the translated string, and the digit 9 was translated into an asterisk

SQL> SQL> SELECT   2       TRANSLATE('4428-2174-5093-1501'   3                ,'0123456789-'   4                ,'0123456789') numbers_only   5  FROM dual; NUMBERS_ONLY ---------------- 4428217450931501