Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

Select replace (beer bucket,beer,milk) as replace_1

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