select regexp_substr('aaa,bbb,ccc','[^,]+',1,level) from dual connect by level<=length('aaa,bbb,ccc')-length(replace('aaa,bbb,ccc',','))+1;