title: Split string by space and character as delimiter in Oracle with regexp_substr
body: <p>I'm trying to split a string with regexp_subtr, but i can't make it work.</p>
  
  <p>So, first, i have this query</p>
  
  <pre><code>select regexp_substr('Helloworld - test!' ,'[[:space:]]-[[:space:]]') from dual
  </code></pre>
  
  <p>which very nicely extracts my delimiter - <em>blank</em>-<em>blank</em></p>
  
  <p>But then, when i try to split the string with this option, it just doesn't work. </p>
  
  <pre><code>select regexp_substr('Helloworld - test!' ,'[^[[:space:]]-[[:space:]]]+')from dual
  </code></pre>
  
  <p>The query returns nothing.</p>
  
  <p>Help will be much appreciated!
  Thanks</p>