title: How to use replace command for multiple characters in PL/SQL
body: <p>I'm writing a procedure that have to replace a set of special characters with another set of them that are accepted to an application system. How can I re-write better the following statement that I'm using in the procedure?  </p>
  
  <pre><code>select     replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace('%BICI* "(MOTO), |X PLAY? 4G: RED&amp;WHITE&amp; \/&lt;DIRETTA&gt;','(','-'),'%','perc'),'?','.'),'|','-'),':',';'),',','.'),'&lt;','-'),'&gt;','-'),'&amp;','and'),'\','-'),'/','-'),'"','-'),')','-'),'*','-')
  from dual;
  </code></pre>
  
  <p>I can't use a recursive procedure. 
  Any suggestions?</p>
  
  <p>Thanks!
  Ilaria</p>