现在有表:
ID ITEM
01 01-A
01 01-B
02 02-A
02 02-B
转换成如下表格式:
ID ITEM
01 01-A, 01-B
02 02-A, 02-B
解决办法:使用WMSYS.WM_CONCAT()函数
测试数据:
DROP TABLE rl_test;
CREATE TABLE rl_test
(id integer,
item varchar2(10),
CONSTRAINT pk_rl_test PRIMARY KEY(id,item));
begin
INSERT INTO rl_test(id,item) VALUES(01,'01-A');
INSERT INTO rl_test(id,item) VALUES(01,'01-B');
INSERT INTO rl_test(id,item) VALUES(02,'02-A');
INSERT INTO rl_test(id,item) VALUES(02,'02-B');
COMMIT;
end;
Screen shot:
Code:
SELECT id,WMSYS.WM_CONCAT(item) new_item FROM rl_test GROUP BY id;
Screen shot:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24025515/viewspace-719088/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24025515/viewspace-719088/