listagg 썸네일형 리스트형 oracle listagg 이용한 union 항목들 구분하기 SELECTDT, MAX(GUBUN), LISTAGG(GUBUN,',') WITHIN GROUP(ORDER BY GUBUN) as GUBUN2FROM(SELECT A.* FROM(SELECT '10:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '11:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '14:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '15:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '16:00' AS DT, 'A' AS GUBUN FROM DUAL) AUNION ALLSELECTB.*FROM(SELECT '12:00' A.. 더보기 이전 1 다음