decode 없이 오라클 행 열 바꾸기2

decode 없이 오라클 행 열 바꾸기2

WITH DATA1 AS (

SELECT '01' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL UNION ALL

SELECT '02' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL UNION ALL

SELECT '03' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL UNION ALL

SELECT '10' AS MM, 100 AS QTY, 200 AS AMT FROM DUAL

)

SELECT *

 FROM (

 SELECT *

    FROM DATA1

    ) PIVOT (

    SUM(QTY) AS QTY,

    SUM(AMT) AS AMT

    FOR

    MM IN ( '01' AS "MM1", '02' AS "MM2", '03' AS "MM3", '10' AS "MM10")

    );(1101,1102,1103,1104,1105))

order by Character;