select regexp_substr('1,2', '[^,]+', 1, level) id
from dual
connect by level <= regexp_count('1,2', '[^,]+');
select regexp_substr('1,2', '[^,]+', 1, level) id
from dual
connect by level <= regexp_count('1,2', '[^,]+');