TRANSLATE(x, from_string, to_string): Converts all occurrences of from_string in x to to_string
SQL> -- TRANSLATE(x, from_string, to_string): Converts all occurrences of from_string in x to to_string.
SQL>
SQL> select translate('1111','1','2') from dual;
TRAN
----
2222
Related examples in the same category