title: Remove special characters from a string in oracle sql
body: <p>The field contains special characters like pipe,returns ,* and (
  example: </p>
  
  <pre><code>Table Name: Employee
  Field names: id, name
  ID   Name
  01   Radhika N (MBA)*MCA*
  02   Venu (BBA)
  03   (MBA)Ananth
  04   Visal **MCA**
  </code></pre>
  
  <p>Now i want a select statement that removes all special characters and my result should be </p>
  
  <pre><code>ID   Name
  01  RADHIKA N
  02  VENU
  03  ANANTH
  04  VISHAL
  
  Select id, upper(replace(replace(replace(replace(replace(replace(name,'|',' '),chr(10),' '),chr(13),' '),chr(9),' '), chr(42), ' '), chr(40), ' ')) as NAME
  from employee 
  </code></pre>
  
  <p>this will take out any ascii special characters and *
  But the result was:</p>
  
  <pre><code>ID   Name
  01  RADHIKA N (MBA) MCA
  02  VENU (BBA)
  03  (MBA) ANANTH
  04  VISHAL MCA
  </code></pre>
  
  <p>How do i remove "(MBA)" from the names?</p>