Programing/Oracle

Oracle !! 열을 - > 행으로 변경!!

My Love Princess 2012. 10. 4. 17:06


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 = A

 GROUP BY A


자아~ 'ㅁ' 이걸 참조해서 'ㅁ' 분석해 보도록!! 


SYS_CONNECT_BY_PATH !!!!