오라클(Oracle) 세로 DATA 가로로 출력 (LISTAGG)
DB/Oracle 2020. 1. 2. 21:56

아래의 예시 결과값은 오라클 라이브 SQL에서 확인 할 수 있습니다. (오라클 11g / 12c 기준) 1. 1개의 컬럼에 세로 ROWDATA 합치기 WITH T AS ( SELECT 1 AS TEXT FROM DUAL UNION ALL SELECT 2 AS TEXT FROM DUAL UNION ALL SELECT 3 AS TEXT FROM DUAL UNION ALL SELECT 4 AS TEXT FROM DUAL UNION ALL SELECT 5 AS TEXT FROM DUAL UNION ALL SELECT 6 AS TEXT FROM DUAL UNION ALL SELECT 7 AS TEXT FROM DUAL UNION ALL SELECT 8 AS TEXT FROM DUAL UNION ALL SELECT..