title: how to remove spaces, special characters and numbers in one oracle sql statement
body: <p>how to remove spaces, special characters and numbers in one oracle sql statement</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>tried so far:</p>
  
  <pre><code>SELECT REGEXP_REPLACE(NAME ,'[^[:alnum:]'' '']', NULL) FROM table
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT translate(NAME,'[0-9]-/^%#-$&amp;&amp;!_. ','[0-9]') last_names FROM table
  </code></pre>