how to replace a substring in pl/sql

[mokesql]

hi!

i want to search a string for a substring and to replace it: if my string would be 'i am searching for a solution of my problem' i would as example would like to replace the substring 'problem' with the substring 'mass'. are there ways of doin it in pl/sql. thnx for the help

kemo

 

[carp]

Try the REPLACE function:

SQL> select replace('i am looking for a problem','problem','answer') from dual;

REPLACE('IAMLOOKINGFORAPR
-------------------------
i am looking for a answer