Oracle function TRANSLATE

function TRANSLATE


select TRANSLATE('12123 3434 4535 5656','0123456789 ','0123456789') from dual
^
|
TRANSLATE('121233
-----------------
12123343445355656

in this case we have not given space translate information so it will trim space



select replace('I am vihaan','vihaan','Anuj') result from dual;

RESULT
---------
I am Anuj