SELECT trim(regexp_substr(str, '[^,]+', 1, level)) strRows
FROM (SELECT '12,1321,1234' as str from dual) t
CONNECT BY instr(str, ',', 1, level - 1) > 0
SELECT trim(regexp_substr(str, '[^,]+', 1, level)) strRows
FROM (SELECT '12,1321,1234' as str from dual) t
CONNECT BY instr(str, ',', 1, level - 1) > 0