数据库拆分字段('1,2')--('1','2')

 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;