오라클 Oracle SYS_CONNECT_BY_PATH 조회된 값을 이어 붙이고 싶으실 때는 SYS_CONNECT_BY_PATH 을 사용하시면 됩니다. SELECT SUBSTR(MAX(SYS_CONNECT_BY_PATH(A, ',')), 2) PATH_1, SUBSTR(MAX(SYS_CONNECT_BY_PATH(B, ',')), 2) PATH_2 FROM ( SELECT ROWNUM RNUM, A, B FROM ( SELECT '가족' A, '아버지' B FROM DUAL UNION SELECT '가족' A, '어머니' B FROM DUAL UNION SELECT '가족' A, '형' B FROM DUAL UNION SELECT '가족' A, '누나' B FROM DUAL UNION SELECT '친가'..