Replace a string by another in cognos using oracle database

Question

i have a string "/folder[@name='Location/louvre']/directory[@name='Documents']" and i want to replace /folder[@name= by "loc>pl", i'm using the replace function but it doesn't work so.

Answer 1

works for me, remember about double quotes:

select 
 replace('/folder[@name=''Location/louvre'']/directory[@name=''Documents'']',
 '/folder[@name=',
 'loc>pl') 
from dual;