ORACLE 11g PIVOT

 

/* 오라클 11g 부터 지원하는 피벗함수 */

 

WITH PIVOT_DATA AS(
 SELECT 'A' AGENCY, 1 CNT FROM dual
 UNION ALL SELECT 'B' AGENCY, 2 CNT FROM dual
 UNION ALL SELECT 'C' AGENCY, 3 CNT FROM dual
 UNION ALL SELECT 'D' AGENCY, 4 CNT FROM dual
 UNION ALL SELECT 'E' AGENCY, 5 CNT FROM dual
 UNION ALL SELECT 'F' AGENCY, 6 CNT FROM dual
 UNION ALL SELECT 'G' AGENCY, 7 CNT FROM dual
)
SELECT * FROM PIVOT_DATA
  PIVOT(SUM(cnt) FOR AGENCY IN ('A', 'B', 'C', 'D', 'E', 'F', 'G'));

 

좋아졌네잉 ~_~;

 

11g 하위 버전에서는

 

ORA-00933 예외 발생함.