title: Splitting string into multiple rows in Oracle
body: <p>I know this has been answered to some degree with PHP and MYSQL, but I was wondering if someone could teach me the simplest approach to splitting a string (comma delimited) into multiple rows in Oracle 10g (preferably) and 11g. </p>
  
  <p>The table is as follows:</p>
  
  <pre><code>Name | Project | Error 
  108    test      Err1, Err2, Err3
  109    test2     Err1
  </code></pre>
  
  <p>I want to create the following:</p>
  
  <pre><code>Name | Project | Error
  108    Test      Err1
  108    Test      Err2 
  108    Test      Err3 
  109    Test2     Err1
  </code></pre>
  
  <p>I've seen a few potential solutions around stack, however they only accounted for a single column (being the comma delimited string). Any help would be greatly appreciated. </p>