Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. Use TRANSLATE() to convert numbers
SQL>
SQL> SELECT TRANSLATE(12345,
  2                   54321,
  3                   67890) FROM dual;
TRANS
-----
09876
SQL>