SQL>
SQL> select translate('beer bucket','beer','milk') as translate
2 , replace ('beer bucket','beer','milk') as replace_1
3 , replace ('beer bucket','beer') as replace_2
4 from dual;
TRANSLATE REPLACE_1 REPLACE
----------- ----------- -------
miik muckit milk bucket bucket
SQL>