实测有效
处理某一列是逗号分割的多条数据,使其变成单独的一条条的数据。
SELECT DISTINCT REGEXP_SUBSTR(JGID, '[^,]+', 1, LEVEL, 'i') AS JGID
FROM (SELECT JGID FROM BXQKKXXB WHERE ROWNUM<100)T
CONNECT BY LEVEL <=LENGTH(JGID) - LENGTH(REGEXP_REPLACE(JGID, ',', '')) + 1
例如jgid=1,2,3,则变成jgid=1,jgid=2,jgid=3的样式。