title: Splitting a variable length delimited string into columns using Oracle SQL
body: <p>I am working on a requirement where in i need to split a comma delimited string into different columns.</p>
  
  <p>This list is of variable length i.e. it can be </p>
  
  <pre><code>               a,b,c,d
                   or
                 a,b,c,d,e
  </code></pre>
  
  <p>and so on. i.e. the no of delimiters and hence the no of columns are not fixed.</p>
  
  <p>Is there any way to achieve it using a SQL query?</p>
  
  <p>I am using Oracle 11gR2 enterprise edition</p>
  
  <p>Thanks </p>
  
  <p>Vishad</p>