Oracle PL/SQL Translate Function

The Translate function replaces a single character at a time with with another character.

The Translate Function syntax:

translate( string, string_to_replace, replacement_string )

Example

select translate('3forms398', '398', '765') from dual; 

would return '7forms765'


select translate('555mysql', '5my', '7pl') from dual;

would return '777plsql'