oracle 열을 행으로 (, 구분)

WITH T AS (

SELECT '0001' AS CD, 'S0001' AS ID, 1 AQS ROWNO FROM DUAL

UNION ALL

SELECT '0002' AS CD, 'S0002' AS ID, 1 AQS ROWNO FROM DUAL

UNION ALL

SELECT '0003' AS CD, 'S0003' AS ID, 1 AQS ROWNO FROM DUAL

)

SELECT SUBSTR(MAX(SYS_CONNECT_BY_PATH(CD,','))), 2) AS CD

FROM T

START WITH ROWNO = 1

CONNECT BY PRIOR ROWNO = ROWNO - 1

결과

0001,0002,0003