Oracle replace function on a string with single quotes and commas
<p>I have a query in the form</p>

<pre><code>SELECT REPLACE(text, 'a','b') 
FROM DUAL;
</code></pre>

<p>if the string text = <code>a','b','c</code></p>

<p>How do I place the string in the replacd function so that it runs correctly?</p>