2014. 2. 25. 11:40
오라클 Row를 한 컬럼으로 변경하기(11g Only) Study/Oracle2014. 2. 25. 11:40
SELECT LISTAGG (ROWNUM, ',') WITHIN GROUP (ORDER BY ROWNUM)
FROM DUAL
CONNECT BY LEVEL <= 10
SELECT LISTAGG (ROWNUM, ',') WITHIN GROUP (ORDER BY ROWNUM) OVER (PARTITION BY ROWNUM)
FROM DUAL
CONNECT BY LEVEL <= 10
자세한 설명은 생략한다
FROM DUAL
CONNECT BY LEVEL <= 10
SELECT LISTAGG (ROWNUM, ',') WITHIN GROUP (ORDER BY ROWNUM) OVER (PARTITION BY ROWNUM)
FROM DUAL
CONNECT BY LEVEL <= 10
자세한 설명은 생략한다