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