개발 참고자료

--------------------------------------------------------------------------------------------------------------------------------------------------------------
- row로 조회되는 것을 가로로 보이게 하는 쿼리(, 로 구분되어서 보임)
--------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT DEPART_CODE, MAJOR_CODE, SUBJECT_CODE, YEAR, GRADE, SEMESTER, PROFESSOR_CODE, CLASS_DIVIDE,
to_char(WM_CONCAT( LECTURE_ROOM )) as LECTURE_ROOM
FROM SUBJECT_VW
GROUP BY DEPART_CODE, MAJOR_CODE, SUBJECT_CODE, YEAR, GRADE, SEMESTER, PROFESSOR_CODE, CLASS_DIVIDE,



SELECT A.CS_YEAR, A.CS_HAKGI, A.CS_PROF, A.CS_GWAMOK, A.CS_BUNBAN,
listagg(B.ROOM_NAME, ', ') within group(order by B.ROOM_NAME) as room_name
FROM CLASS_HOUR A, LESSON_ROOM B
WHERE A.CS_LESSON_ROOM = B.ROOM_CODE
GROUP BY A.CS_YEAR, A.CS_HAKGI, A.CS_PROF, A.CS_GWAMOK, A.CS_BUNBAN