SELECT '('||''''||REPLACE('1,2,3',',',''',''')||''''||')' FROM DUAL;
SELECT REGEXP_SUBSTR('1,2', '[^,]+', 1, LEVEL) AS STR
FROM DUAL
CONNECT BY LEVEL <=
LENGTH('1,2') - LENGTH(REGEXP_REPLACE('1,2', ',', '')) + 1;
SELECT REGEXP_SUBSTR('1,2', '[^,]+', 1, LEVEL) AS STR
FROM DUAL
CONNECT BY LEVEL <=
LENGTH('1,2') - LENGTH(REGEXP_REPLACE('1,2', ',', '')) + 1;