oracle行转列函数

REGEXP_SUBSTR是ORACLE函数 结果已验证SELECT '1',REGEXP_SUBSTR('a,b', '[^,]+', 1, LEVEL, 'i') AS STR FROM DUAL CONNECT BY LEVEL <= LENGTH('a,b') - LENGTH(REGEXP_REPLACE('a,b', ',', ''))+1;