행을 열로 바꾸기. with as( ~ )

뚤뚤~~~
refresh ~, renew ~

WITH T AS(
    SELECT '3234' A,'태희' B FROM DUAL UNION ALL
    SELECT '7777', '양민' FROM DUAL UNION ALL
    SELECT '0792', '수애' FROM DUAL UNION ALL
    SELECT '2345', '지현' FROM DUAL UNION ALL
    SELECT '2345', '영애' FROM DUAL UNION ALL
    SELECT '2345', '수진' FROM DUAL
)
SELECT T.A
       ,MAX(SYS_CONNECT_BY_PATH(T.B,'||')) B
FROM (
        SELECT T.A
               ,T.B
               ,COUNT(T.A) OVER (PARTITION BY T.A) CNT
               ,ROWNUM RN
        FROM T
      ) T 
WHERE LEVEL = T.CNT
GROUP BY T.A
CONNECT BY PRIOR T.RN=T.RN-1

수행결과
=>

792	||수애
2345	||지현||영애||수진
3234	||태희
7777	||양민