1 2 3 4 5 6 7 8 9 | select LTRIM( SUBSTR( MAX ( SYS_CONNECT_BY_PATH( COLUMN_NAME, ', ' ) ), 2 ) ) as "OUTPUT_COLUMN" from ( select 1 as INDEX_NO, 'AAA' as COLUMN_NAME FROM DUAL union all select 2 as INDEX_NO, 'BBB' as COLUMN_NAME FROM DUAL union all select 3 as INDEX_NO, 'CCC' as COLUMN_NAME FROM DUAL ) start with INDEX_NO = 1 connect by prior INDEX_NO = INDEX_NO - 1 |
위와 같은 쿼리로 각 Row의 데이터를 하나의 Row로 출력할 수 있다.
덧글을 달아 주세요