자주나오는 질문인데요.  조회하면 많이 있긴합니다.

일정한 기간없이 무작위로 컬럼을 추가해서 만든다고 하면 DYNAMIC SQL 사용해야합니다.

단. 2015년만 할것이다 하면 12월까지 고정값을 가지고 STATIC SQL로 만들수있습니다.

어떤형태 이신가요?

WITH T AS (
SELECT '201501' YYYYMM , 'A' DEPT,  1 CNT ,  0 NIGHT_CNT FROM DUAL UNION ALL   
SELECT '201501' , 'B' ,  2  ,  0 FROM DUAL UNION ALL   
SELECT '201502' , 'A' ,  2  ,  0 FROM DUAL UNION ALL   
SELECT '201503' , 'C' ,  1  ,  1 FROM DUAL UNION ALL   
SELECT '201503' , 'D' ,  1  ,  1 FROM DUAL UNION ALL   
SELECT '201507' , 'F' ,  1  ,  1 FROM DUAL UNION ALL
SELECT '201512' , 'F' ,  1  ,  1 FROM DUAL 
)

-- GROUP BY - MAX 이용 ( 10G 이하 ) 
SELECT DEPT
     , MAX(CASE WHEN MM = 01 THEN CNT END ) AS CNT_01
     , MAX(CASE WHEN MM = 01 THEN NIGHT_CNT END) AS  NIGHT_CNT_01
     , MAX(CASE WHEN MM = 02 THEN CNT END ) AS CNT_02
     , MAX(CASE WHEN MM = 02 THEN NIGHT_CNT END) AS  NIGHT_CNT_02
     , MAX(CASE WHEN MM = 03 THEN CNT END ) AS CNT_03
     , MAX(CASE WHEN MM = 03 THEN NIGHT_CNT END) AS  NIGHT_CNT_03
     , MAX(CASE WHEN MM = 04 THEN CNT END ) AS CNT_04
     , MAX(CASE WHEN MM = 04 THEN NIGHT_CNT END) AS  NIGHT_CNT_04
     , MAX(CASE WHEN MM = 05 THEN CNT END ) AS CNT_05
     , MAX(CASE WHEN MM = 05 THEN NIGHT_CNT END) AS  NIGHT_CNT_05
     , MAX(CASE WHEN MM = 06 THEN CNT END ) AS CNT_06
     , MAX(CASE WHEN MM = 06 THEN NIGHT_CNT END) AS  NIGHT_CNT_06
     , MAX(CASE WHEN MM = 07 THEN CNT END ) AS CNT_07
     , MAX(CASE WHEN MM = 07 THEN NIGHT_CNT END) AS  NIGHT_CNT_07
     , MAX(CASE WHEN MM = 08 THEN CNT END ) AS CNT_08
     , MAX(CASE WHEN MM = 08 THEN NIGHT_CNT END) AS  NIGHT_CNT_08
     , MAX(CASE WHEN MM = 09 THEN CNT END ) AS CNT_09
     , MAX(CASE WHEN MM = 09 THEN NIGHT_CNT END) AS  NIGHT_CNT_09
     , MAX(CASE WHEN MM = 10 THEN CNT END ) AS CNT_10
     , MAX(CASE WHEN MM = 10 THEN NIGHT_CNT END) AS  NIGHT_CNT_10
     , MAX(CASE WHEN MM = 11 THEN CNT END ) AS CNT_11
     , MAX(CASE WHEN MM = 11 THEN NIGHT_CNT END) AS  NIGHT_CNT_11
     , MAX(CASE WHEN MM = 12 THEN CNT END ) AS CNT_12
     , MAX(CASE WHEN MM = 12 THEN NIGHT_CNT END) AS  NIGHT_CNT_12

  FROM (SELECT YYYYMM 
             , SUBSTR(YYYYMM,5,2) MM
             , DEPT 
             , SUM(CNT) CNT 
             , SUM(NIGHT_CNT) NIGHT_CNT
          FROM T 
         WHERE YYYYMM BETWEEN '201501' AND '201512' 
         GROUP BY YYYYMM , DEPT
        )
 GROUP BY DEPT
 ORDER BY DEPT



-- PIVOT 이용 ( 11G 이상 )
SELECT *
  FROM (SELECT SUBSTR(YYYYMM,5,2) MM
             , DEPT 
             , SUM(CNT) CNT 
             , SUM(NIGHT_CNT) NIGHT_CNT
          FROM T 
         WHERE YYYYMM BETWEEN '201501' AND '201512' 
         GROUP BY YYYYMM , DEPT
        )
  PIVOT ( SUM(CNT) CNT, SUM(NIGHT_CNT) NIGHT_CNT
          FOR MM IN ( '01' , '02' , '03' , '04' , '05' , '06' , '07' , '08' , '09' , '10' , '11' , '12' ))