Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

Use TRANSLATE() to convert numbers

SQL> SQL> SELECT TRANSLATE(12345,   2                   54321,   3                   67890) FROM dual; TRANS ----- 09876 SQL>