instr函数不会用啊
1,4--->张三,赵六怎么转呢?
instr 只是判定 ,判定完之后wm_concat才是转换,对了,wm_concat是组函数,和group一起用
select ci_id,wm_concat(stu_name) stu_name
from pn_ci a,pm_stu b
where instr(stu_ids,stu_id)>0
group by ci_id;