oracle 逗号分隔的字符串列字段查询列出多条记录

时间:2022-01-03 00:49:46

表名(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