oracle 逗号分隔列转多行数据(动态)
Oracle APEX
date table below:
test SQL:
SELECT Active_yn, REGEXP_SUBSTR(DAYS, '[^,]+', 1, LEVEL) NAME
FROM Joe
CONNECT BY LEVEL <= REGEXP_COUNT(DAYS, '[^,]+')
AND ROWID = PRIOR ROWID
AND PRIOR DBMS_RANDOM.VALUE IS NOT NULL
ORDER BY DAYS;
TEST SQL result below: