Mega Code Archive
Categories
/
Oracle PLSQL
/
Char Functions
TRANSLATE(x, from_string, 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