select regexp_substr('abc,bcd', '[^,]+', 1, level) from dual connect by level <= length('abc,bcd') - length(replace('abc,bcd', ',')) + 1