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;