title: Replacing multiple CHR() from PLSQL string
body: <p>I have a PLSQL string which contains chr() special characters like chr(10), chr(13). I want to replace these special characters from the string. I tried the following ways</p>
  
  <pre><code>select  regexp_replace('Hello chr(10)Goodchr(13)Morning','CHR(10)|chr(13)','') from dual;
  </code></pre>
  
  <p>This do not works since regexp_replace do not replace chr() function. Then I tried</p>
  
  <pre><code>select translate('Hello chr(10)Goodchr(13)Morning', 'chr(10)'||'chr(13)', ' ') from dual;
  </code></pre>
  
  <p>It works partially, ie; I am forced to replace chr() with white space(third parameter). No option if I do not want to replace chr() with white spaces . If I pass third character as null then above query returns null result.
  Anybody have any other methods?</p>