功能目标:多值列通过特定分隔符分割后关联表
基础表:学生表 student
基础表:学院表 department
预期效果
SQL语句
select ID AS IDS,
STU_NAME,
DEP_CODE,
(select listagg(department.DEP_NAME, ',') within group (order by department.DEP_ID) FROM DEPARTMENT WHERE instr(','||student.DEP_CODE||',', ','||department.DEP_ID||',') >0 ) AS DEPARTNA
from student;
oracle在线运行网站:http://livesql.oracle.com