title: Oracle SQL: select regexp_substr, "into clause is expected"
body: <p>I am trying to split a comma delimited string using regexp_substr, but get "into clause is expected" error:</p>
  
  <pre><code> select regexp_substr(improv,'[^,]+', 1, level) from dual
   connect by regexp_substr(improv, '[^,]+', 1, level) is not null;
  </code></pre>
  
  <p>"improv" is a varchar(100) variable, and I am running the above statement inside a PLSQL block.</p>