17,086
社区成员
发帖
与我相关
我的任务
分享
--9i
SELECT ltrim(MAX(sys_connect_by_path(result_SN, '#')), '#')
FROM (SELECT rownum rn, result_SN FROM tai_dc_resdata)
START WITH rn = 1
CONNECT BY PRIOR rn = rn - 1;
--10g
SELECT REPLACE(wm_concat(result_SN), ',', '#') FROM tai_dc_resdata;
--11gr2
SELECT LISTAGG(result_SN, '#') WITHIN GROUP(ORDER BY result_SN)
FROM tai_dc_resdata;