wm_concat 이 안되는 환경(여러개의 레코드를 하나의 필드로)

select LTRIM(sys_connect_by_path(name,'|'),'|') AS column_name from (
SELECT ROW_NUMBER() OVER (PARTITION BY ADD_SVC_BANK ORDER BY ADD_SVC_CODE) RID,
COUNT (*) OVER (partition by ADD_SVC_BANK ) cnt,
ADD_SVC_CODE, ADD_SVC_BANK, ADD_SVC_CODE || ADD_SVC_NAME AS name
FROM VM_ARC_SVC_LIST
WHERE ADD_SVC_BANK = 'VM00010'
)
where level = cnt
start with RID = 1
connect by prior ADD_SVC_BANK = ADD_SVC_BANK
and prior RID = RID-1;


출처
m.blog.naver.com/PostView.nhn?blogId=eemmjj2k&logNo=140106191524