Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. 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