wm_concat

sys_connect_by_path 대신 wm_concat 사용.

성능은 모르겠지만.. 일단 편하다..!!!!

select bb_uid, substr(max(sys_connect_by_path(contents, ',')), 2) as contents
from (
    select bb_uid, contents, row_number() over (partition by bb_uid order by seq) as rnum
    from aps_bbs_contents
)
start with rnum = 1
connect by prior rnum = rnum - 1 and prior bb_uid = bb_uid
group by bb_uid
order by bb_uid;

------------------------------------------------------------------------------------------------------------------------

select bb_uid, wm_concat(contents) as contents
from aps_bbs_contents
group by bb_uid;