REPLACE and TRANSLATE Functions

Translate lets you character by character substitute or one-to-one substitutions whereas REPLACE  is  used to substitute single character by word.

its syntax is :- Translate  (‘str’,’source’,’target’)

REPLACE  (‘str’,’source’,’target’)

Example:
 F:\>cd F:\app\dell\virtual\product\12.2.0\dbhome_1\bin
 F:\app\dell\virtual\product\12.2.0\dbhome_1\bin>sqlplus/nolog
 SQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 28 03:04:20 2022
 Copyright (c) 1982, 2016, Oracle.  All rights reserved.
 SQL> conn sys/orcl@orcl as sysdba
Connected.
SQL> select translate('welecome','ec','ab') from dual;
 TRANSLAT
--------
walaboma
 SQL> select replace('welecome','come','test') from dual;
 REPLACE(
--------
weletest