title: Splitting comma separated values in Oracle
body: <p>I have column in my database where the values are coming like the following:</p>
  
  <pre><code>3862,3654,3828
  </code></pre>
  
  <p>In dummy column any no. of comma separated values can come. I tried with following query but it is creating duplicate results.</p>
  
  <pre><code>select regexp_substr(dummy,'[^,]+',1,Level) as dummycol 
    from (select * from dummy_table) 
   connect by level &lt;= length(REGEXP_REPLACE(dummy,'[^,]+'))+1
  </code></pre>
  
  <p>I am not understanding the problem.  Can anyone can help?</p>