逗号分割查询数据

with p as (
  select distinct cst_no,projects from tb_user_results
),
a as (
  select cst_no,regexp_substr(projects,'[",]+',1,lev) as projects
  from p,(select level lev from dual connect by level <=1000) b
  where lev<=length(projects) - length(regexp_replace(projects,',',''))+1
)
select distinct a.cst_no,b.project,b.project_name
from a
join b on a.projects=b.project
where a.projects is not null
order by a.cst_no,b,project