练习作业提交

select

ci_id

,(select listagg(stu_name,',') within group(order by stu_id) 

 from pm_stu where instr(pc.STU_IDS,stu_id)>0) stu_names

from pm_ci pc

;