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

Question

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

예를들어서

SELECT NAME FROM DUAL;

했을때

A

B

C

D

이렇게 나오는게

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

어떻게 해야하나요?

Answer 1

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