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