oracle PIVOT, UNPIVOT

행을 열로

열을 행으로

WITH T AS (

   SELECT 'AA' AS KEY1, 

          'BB' AS KEY2,

           10  AS VAL1,

           20  AS VAL2

     FROM DUAL 

UNION ALL 

   SELECT 'CC' AS KEY1, 

          'DD' AS KEY2, 

           30  AS VAL1,

           40  AS VAL2

     FROM DUAL 

)

SELECT KEY1 AS KEY_, VAL1 AS VAL_ FROM T UNPIVOT (KEY1 FOR G IN (KEY1))

UNION ALL

SELECT KEY2, VAL2 FROM T UNPIVOT (KEY2 FOR G IN (KEY2))

  ->