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