오라클 DB에서 SELECT 한 결과를 가로,세로 변환하는 방법은 무엇인가요?

Question

예를들어서

SELECT NAME FROM DUAL;

했을때

A

B

C

D

이렇게 나오는게

A B C D 이렇게 나오고 싶습니다.

어떻게 해야하나요?

얄쌍한재규어4 · Accepted Answer

WITH T_TEMP AS    (SELECT 'T1' AS COL, 'A' AS ITEM FROM DUAL UNION ALL     SELECT 'T2' AS COL, 'B' AS ITEM FROM DUAL UNION ALL     SELECT 'T3' AS COL, 'C' AS ITEM FROM DUAL UNION ALL     SELECT 'T4' AS COL, 'D' AS ITEM FROM DUAL    )    SELECT MAX(DECODE(COL, 'T1',ITEM)) AS T1          ,MAX(DECODE(COL, 'T2',ITEM)) AS T2          ,MAX(DECODE(COL, 'T3',ITEM)) AS T3	  ,MAX(DECODE(COL, 'T4',ITEM)) AS T4      FROM T_TEMP

생활꿀팁

생활꿀팁

오라클 DB에서 SELECT 한 결과를 가로,세로 변환하는 방법은 무엇인가요?