Oracle !! 열을 - > 행으로 변경!!
SELECT A, SUBSTR(MAX(SYS_CONNECT_BY_PATH(B, ',')), 2) AS B FROM (SELECT A , B , ROW_NUMBER() OVER(PARTITION BY A ORDER BY A) AS RNUM FROM (SELECT 1 A , '엄마' B FROM DUAL UNION ALL SELECT 1 A , '아빠' B FROM DUAL UNION ALL SELECT 1 A , '이모' B FROM DUAL UNION ALL SELECT 2 A , '삼촌' B FROM DUAL UNION ALL SELECT 2 A , '오빠' B FROM DUAL) ) START WITH RNUM = 1 CONNECT BY PRIOR RNUM = RNUM - 1 AND PRIOR A =..
더보기