表名（id,逗号分隔的列名）

select id,逗号分隔的列名from (select distinct id,regexp_substr(逗号分隔的列名,'[^,]+',1,level) 逗号分隔的列名 from表名 where 逗号分隔的列名 is not null connect by level <= regexp_count(逗号分隔的列名,',') + 1 and id = prior id and prior dbms_random.value is not null