PL/SQL Translate

The TRANSLATE function replaces a single character with another character.

Translate syntax

TRANSLATE( string, string_to_replace, replacement_string )

Translate example

 
select translate('7test721', '721', '834') from dual;		

Result: 8test834


select translate('111sql4156', '1', '3') from dual;	

Result: 333sql4356


select translate('oradev', 'dev', 'cle') from dual;	

Result: oracle


select translate('database 1', '1', '2') from dual;	

Result: database 2

↑