Oracle 썸네일형 리스트형 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.. 더보기 Oracle dynamic date 오라클 동적 시간 만들기 SELECT level AS id, current_timestamp - interval '1' second*level,SYSDATE - (interval '1' second)*levelFROM dual CONNECT BY level 더보기 ORACLE WITH oracle with문.. 요즘 잘 안쓰다보니 사용법을 까먹게 생겨서 기록해놓는다. with A as ( select ...필요한 데이터 A ), B as ( select ... 필요한 데이터 B ), C as ( select ... 필요한 데이터 C )RESULT as (select A.*, B.*, C.*from A, B, Cwhere A.id = B.idand A.id = C.id)select * from RESULT 이런식으로 쓰면 유용하게 써먹을 수 있겠다.. 더보기 이전 1 다음