关于oracle数据库的一道面试题,使用wm_concat()主函数完成答:WITH div_pm_ci AS(select ci_id, substr( stu_ids, instr(','|| stu_ids, ',', 1, rn),instr( stu_ids||',', ',', 1, rn) - instr(','|| stu_ids, ',', 1, rn) ) stu_id from pm_ci,(select rownum rn from dual connect by rownum < 10)where instr(','|| ...