Parse string to a query

with test as (select 'ABC,DEF,GHI,JKL,MNO' str from dual)
select regexp_substr (str, '[^,]+', 1, rownum) split
from test
connect by level <= length (regexp_replace (str, '[^,]+'))  + 1