Oracle 字段值按逗号拆分，变为多行数据

select distinct * from (
select regexp_substr(q.nums, '[^,]+', 1, Level,'i') order_num, names
  from (
  select '1,2,3' nums, '张三' names from dual
  union all
  select '4,5' nums, '李四' names from dual
  union all
  select '5,6' nums, '王五' names from dual
  ) q
connect by Level <= LENGTH(q.nums) - LENGTH(REGEXP_REPLACE(q.nums, ',', '')) + 1) order by order_num;

转载：https://blog.csdn.net/weixin_42403127/article/details/104295906?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168907087016800226560948%2522%252C%2522scm%2522%253A%252220140713.130102334…%2522%257D&request_id=168907087016800226560948&biz_id=0&spm=1018.2226.3001.4187