열을 행으로, 세로 데이터를 가로로 ( 콤마(,)로 구분하여 붙여서) 출력하기
SELECT id, SUBSTR( MAX( SYS_CONNECT_BY_PATH(nm, ',')
) , 2) AS nm
FROM (
SELECT object_type as id, object_name as
nm,
ROW_NUMBER() OVER( PARTITION
BY object_type ORDER BY object_type) rnum
FROM user_objects
)
START WITH rnum = 1
CONNECT BY PRIOR rnum = rnum - 1 AND PRIOR id=
id
GROUP BY
id
엠엔피시스템
정보전략팀장 : 왕희복
) , 2) AS nm
FROM (
SELECT object_type as id, object_name as
nm,
ROW_NUMBER() OVER( PARTITION
BY object_type ORDER BY object_type) rnum
FROM user_objects
)
START WITH rnum = 1
CONNECT BY PRIOR rnum = rnum - 1 AND PRIOR id=
id
GROUP BY
id
엠엔피시스템
정보전략팀장 : 왕희복