用逗号分隔可以吗? select id, wmsys.wm_concat(name) from A group by id;
select id,replace(wmsys.wm_concat(name),',','/') from A group by id;
-- 如果数据库是10g的话: SELECT ID, REPLACE(WMSYS.WM_CONCAT(NAME),',','/') "NEW_NAME" FROM TABLE_NAME TT GROUP BY ID;
适用8i以后的: SELECT t.id id, MAX(substr(sys_connect_by_path(t.name, '/'), 2)) str FROM (SELECT id, name, row_number() over(PARTITION BY id ORDER BY name) rn FROM TABLE_NAME) t START WITH rn = 1 CONNECT BY rn = PRIOR rn + 1 AND id = PRIOR id GROUP BY t.id; 适用于10g以后: SELECT ID, REPLACE(WMSYS.WM_CONCAT(NAME),',','/') "NEW_NAME" FROM TABLE_NAME TT GROUP BY ID;
select id, wmsys.wm_concat(name) from A group by id;
SELECT ID,
REPLACE(WMSYS.WM_CONCAT(NAME),',','/') "NEW_NAME"
FROM TABLE_NAME TT
GROUP BY ID;
SELECT t.id id, MAX(substr(sys_connect_by_path(t.name, '/'), 2)) str
FROM (SELECT id, name, row_number() over(PARTITION BY id ORDER BY name) rn
FROM TABLE_NAME) t
START WITH rn = 1
CONNECT BY rn = PRIOR rn + 1
AND id = PRIOR id
GROUP BY t.id;
适用于10g以后:
SELECT ID,
REPLACE(WMSYS.WM_CONCAT(NAME),',','/') "NEW_NAME"
FROM TABLE_NAME TT
GROUP BY ID;