WITH DT AS
(
SELECT 1 AS M_RN, 'A' AS COL1, 'a' AS COL2 FROM DUAL
UNION ALL SELECT 2 AS M_RN, 'B' AS COL1, 'b' AS COL2 FROM DUAL
UNION ALL SELECT 3 AS M_RN, 'C' AS COL1, 'c' AS COL2 FROM DUAL
UNION ALL SELECT 4 AS M_RN, 'D' AS COL1, 'd' AS COL2 FROM DUAL
UNION ALL SELECT 5 AS M_RN, 'E' AS COL1, 'e' AS COL2 FROM DUAL
UNION ALL SELECT 6 AS M_RN, 'F' AS COL1, 'f' AS COL2 FROM DUAL
UNION ALL SELECT 7 AS M_RN, 'G' AS COL1, 'g' AS COL2 FROM DUAL
UNION ALL SELECT 8 AS M_RN, 'H' AS COL1, 'h' AS COL2 FROM DUAL
UNION ALL SELECT 9 AS M_RN, 'I' AS COL1, 'i' AS COL2 FROM DUAL
UNION ALL SELECT 10 AS M_RN, 'J' AS COL1, 'j' AS COL2 FROM DUAL
UNION ALL SELECT 11 AS M_RN, 'K' AS COL1, 'k' AS COL2 FROM DUAL
UNION ALL SELECT 12 AS M_RN, 'L' AS COL1, 'l' AS COL2 FROM DUAL
)
SELECT * FROM DT
위 데이터를 M_RN기준으로 가로로 조회하고 싶어 문의 드립니다.
C1 | C2 | C3 | C4 | C5 | C6 | ... | C12
A | B | C | D | E | F | ... | L
a | b | c | d | e | f | ... | l
|