explode comma separated string in pl/sql

select regexp_substr('A,B,C,D,E','[^,]+',1,level) from dual connect by regexp_substr('A,B,C,D,E', '[^,]+', 1, level) is not null

Written by Knilluz on 13 August 2014 at 14:59