orcale中把查询结果是逗号多个人员的数据转换为单行，过滤重复的

1.原本图

 2.解决方法

select regexp_substr(a.numbers,'[^,]+',1,level) as numbers 
from (select distinct id,numbers from project where isdelete=0 and isactive=1 and nvl(objstatus,'402881e50c717307010c719745ce0009')!='402881e50c717307010c7196ed980008')  a
connect by  a.id =  a.id
and level <= REGEXP_COUNT(a.numbers,'[^,]+') 
group by regexp_substr(a.numbers,'[^,]+',1,level)