행을 열으로 바꿈

SELECT
    DECODE(B.rn,
        1, 'SUM0',
        2, 'SUM1',
        3, 'SUM2',
        4, 'SUM3',
        5, 'SUM4',
        6, 'SUM5',
        7, 'SUM6',
        8, 'SUM7',
        9, 'SUM8',
        10, 'SUM9',
        11, 'SUM10',
        12, 'SUM11',
        13, 'SUM12',
        14, 'SUM13',
        15, 'SUM14',
        16, 'SUM15',
        17, 'SUM16',
        18, 'SUM17',
        19, 'SUM18',
        20, 'SUM19',
        21, 'SUM20',
        22, 'SUM21',
        23, 'SUM22',
        24, 'SUM23'
        ) "시간",
    DECODE(B.rn,
        1, A.SUM0,
        2, A.SUM1,
        3, A.SUM2,
        4, A.SUM3,
        5, A.SUM4,
        6, A.SUM5,
        7, A.SUM6,
        8, A.SUM7,
        9, A.SUM8,
        10, A.SUM9,
        11, A.SUM10,
        12, A.SUM11,
        13, A.SUM12,
        14, A.SUM13,
        15, A.SUM14,
        16, A.SUM15,
        17, A.SUM16,
        18, A.SUM17,
        19, A.SUM18,
        20, A.SUM19,
        21, A.SUM20,
        22, A.SUM21,
        23, A.SUM22,
        24, A.SUM23
        ) "COUNT"
FROM (
        SELECT
            SUM(CLK0) AS SUM0,
            SUM(CLK1) AS SUM1,
            SUM(CLK2) AS SUM2,
            SUM(CLK3) AS SUM3,
            SUM(CLK4) AS SUM4,
            SUM(CLK5) AS SUM5,
            SUM(CLK6) AS SUM6,
            SUM(CLK7) AS SUM7,
            SUM(CLK8) AS SUM8,
            SUM(CLK9) AS SUM9,
            SUM(CLK10) AS SUM10,
            SUM(CLK11) AS SUM11,
            SUM(CLK12) AS SUM12,
            SUM(CLK13) AS SUM13,
            SUM(CLK14) AS SUM14,
            SUM(CLK15) AS SUM15,
            SUM(CLK16) AS SUM16,
            SUM(CLK17) AS SUM17,
            SUM(CLK18) AS SUM18,
            SUM(CLK19) AS SUM19,
            SUM(CLK20) AS SUM20,
            SUM(CLK21) AS SUM21,
            SUM(CLK22) AS SUM22,
            SUM(CLK23) AS SUM23
        FROM XXXXX
     ) A,
(SELECT ROWNUM rn FROM dual CONNECT BY LEVEL <=24) B;