Mega Code Archive
Categories
/
Oracle PLSQL
/
Char Functions
TRANSLATE()
SQL> SQL> -- TRANSLATE(): convert numbers SQL> SQL> SELECT TRANSLATE(12345, 2 54321, 3 67890) FROM dual; TRANS ----- 09876 SQL>