SELECT 'A1' AS COL1
,'A2' AS COL2
,'A3' AS COL3
,'G1' AS COL_A
FROM DUAL
UNION ALL
SELECT 'A1' AS COL1
,'A2' AS COL2
,'A3' AS COL3
,'G2' AS COL_A
FROM DUAL
UNION ALL
SELECT 'A1' AS COL1
,'A2' AS COL2
,'A3' AS COL3
,'G3' AS COL_A
FROM DUAL
UNION ALL
SELECT 'B1' AS COL1
,'B2' AS COL2
,'B3' AS COL3
,'G1' AS COL_A
FROM DUAL
UNION ALL
SELECT 'B1' AS COL1
,'B2' AS COL2
,'B3' AS COL3
,'G2' AS COL_A
FROM DUAL
UNION ALL
SELECT 'B1' AS COL1
,'B2' AS COL2
,'B3' AS COL3
,'G3' AS COL_A
FROM DUAL
-- COL_A는 가변(현재 ROW가 3이지만 4, 5도 될수 있음)
----------------------------------------------------------
COL1 COL2 COL3 COL_A
----------------------------------------------------------
A1 A2 A3 G1
A1 A2 A3 G2
A1 A2 A3 G3
B1 B2 B3 G1
B1 B2 B3 G2
B1 B2 B3 G3
-- 를 아래와 같이 오라클 11g의 PIVOT(DECODE는 아니고)으로 구현할려고 합니다.
SELECT 'A1' AS COL1
,'A2' AS COL2
,'A3' AS COL3
,'G1' AS COL_A
,'G2' AS COL_B
,'G3' AS COL_C
FROM DUAL
UNION ALL
SELECT 'B1' AS COL1
,'B2' AS COL2
,'B3' AS COL3
,'G1' AS COL_A
,'G2' AS COL_B
,'G3' AS COL_C
FROM DUAL
----------------------------------------------------------------------------
COL1 COL2 COL3 COL_A COL_B COL_C
----------------------------------------------------------------------------
A1 A2 A3 G1 G2 G3
B1 B2 B3 G1 G2 G3
--가능할까요?
|