Character String Functions Oracle PLSQL Tutorial

SQL>
SQL> select replace  ('beer bucket','beer','milk') as replace_1
  2  from   dual;
REPLACE_1
-----------
milk bucket
SQL>