SQL>SQL> select translate('beer bucket','beer','milk') as translate 2 from dual;TRANSLATE-----------miik muckitSQL>