title: Split comma separated values of a column in row, through Oracle SQL query
body: <p>I have a table like below:</p>
  
  <pre><code>-------------
  ID   | NAME
  -------------
  1001 | A,B,C
  1002 | D,E,F
  1003 | C,E,G
  -------------
  </code></pre>
  
  <p>I want these values to be displayed as:</p>
  
  <pre><code>-------------
  ID   | NAME
  -------------
  1001 | A
  1001 | B
  1001 | C
  1002 | D
  1002 | E
  1002 | F
  1003 | C
  1003 | E
  1003 | G
  -------------
  </code></pre>
  
  <p>I tried doing:</p>
  
  <pre><code>select split('A,B,C,D,E,F', ',') from dual; -- WILL RETURN COLLECTION
  
  select column_value
  from table (select split('A,B,C,D,E,F', ',') from dual); -- RETURN COLUMN_VALUE
  </code></pre>