여러 열의 Data 한열로 합치기

 

SELECT C_CD
     , APPL_ID
     , SUBSTR(MAX(SYS_CONNECT_BY_PATH (CURRENT_NM, '/ ')),2) AS CURRENT_NM
     , SUBSTR(MAX(SYS_CONNECT_BY_PATH (DTL, '/ ')),2) AS DTL
     , SUM(ETC_MON) AS TOT_MON
FROM (
SELECT C_CD
     , APPL_ID
     , F_GET_CODE_LANGNM(C_CD, '00050', CURRENT_CD, :LANG_TYPE, 'SY5020L') AS CURRENT_NM
     , CURRENT_CD
     , ETC_MON AS DTL
     , ETC_MON
     , ROW_NUMBER() OVER(PARTITION BY C_CD, APPL_ID  ORDER BY SEQ_NO) AS RN
FROM BE8250
WHERE C_CD = :C_CD
AND APPL_ID = :APPL_ID)
START WITH RN = 1    
CONNECT BY PRIOR RN = RN - 1
AND PRIOR C_CD = C_CD
AND PRIOR APPL_ID = APPL_ID
GROUP BY C_CD, APPL_ID

 

빨간부분이 키포인트...

 

출처 : http://blog.naver.com/PostPrint.nhn?blogId=pluggers&logNo=150031521606