Dividing comma separated strings into columns
Is this what you're looking for? I'm using regexp_substr

with test as
(select '1,2,3' col1, 'Ab,cd,ef' col2 from dual)
  select regexp_substr(col1, '[^,]+', 1, rownum) result1, regexp_substr(col2, '[^,]+', 1, rownum) result2
  from test
  connect by level &lt;= length(regexp_replace(col1, '[^,]+')) + 1;


This is the SQL Fiddle.