Originally Posted by WilliamR
What a coincidence! I blogged about the same problem today. Try this:
Originally Posted by dinesh_hm
select substr (replace ('a,b,c', ','), rownum, 1)
where rownum <= length (replace ('a,b,c', ','));
Your solution will work only for single digit elements
what if the string has elements like 'abc','qwerty' etc ?
Click Here to Expand Forum to Full Width