목록Oracle LISTAGG 사용 예시 (3)

깜놀하는 해므찌로

Oracle LISTAGG 사용 예시 / Mysql GROUP_CONCAT

/* VO.excelDownSelectList */ '' THEN '첨부' ELSE '미첨부' END atchFileId , CASE WHEN A.USE_YN = 'Y' THEN '사용' ELSE '미사용' END useYn , CASE WHEN A.STATE = 'Y' THEN '확인' ELSE '미확인' END state , A.EAT_DATEeatDate , NVL((SELECT LISTAGG(NAME || '(' || TC.C_CODE_NM || ')', ', ') WITHIN GROUP(ORDER BY A.USER_SEQ) FROM t_ad_user TAD LEFT OUTER JOIN T_CODE TC ON TC.C_CODE = TAD.POSITION WHERE A.USER_SEQ LIKE '%..
IT 2022. 9. 8. 08:53
Oracle LISTAGG 사용 예시 / [직급]이름(시간) 테이블 4개 참조 예시

/* VO.selectList */ '0' THEN A.TOTAL_HOUR||'시간' ELSE '' END ||CASE WHEN A.TOTAL_MIN IS NOT NULL AND A.TOTAL_MIN '0' THEN A.TOTAL_MIN||'분' ELSE '' END||')',', ') WITHIN GROUP(ORDER BY A.AD_SEQ) emplyName FROM T_OVER_ADD A LEFT OUTER JOIN T_AD_USER B ON B.SEQ = REPLACE(REPLACE(A.EMPLY_SEQ, '[', ''), ']', '') AND B.USE_YN = 'Y' LEFT OUTER JOIN T_CODE CD ON CD.C_CODE = B.POSITION WHERE A.USE_YN = 'Y..
IT 2022. 8. 23. 10:24
Oracle LISTAGG 실전 사용 예시 / MySQL GROUP_CONCAT / LEFT OUTER JOIN

/* vo.excelDownSelectList*/ '0' THEN A.TOTAL_HOUR||'시간' ELSE '' END ||CASE WHEN A.TOTAL_MIN IS NOT NULL AND A.TOTAL_MIN '0' THEN A.TOTAL_MIN||'분' ELSE '' END||')',', ') WITHIN GROUP(ORDER BY A.AD_SEQ) emplyName FROM T_OVER_ADD A LEFT OUTER JOIN T_AD_USER B ON A.EMPLY_SEQ = B.SEQ AND B.USE_YN = 'Y' WHERE A.USE_YN = 'Y' GROUP BY A.OT_SEQ ) B ON A.OT_SEQ = B.OT_SEQ LEFT OUTER JOIN T_AD_USER C ON A...
IT 2022. 8. 5. 20:43
이전 Prev 1 Next 다음