-- 删除主外键的表
drop table tabs cascade constraints;
--
create table t_one_many(tcode varchar2(32),tm varchar2(2));
insert into t_one_many (TCODE, TM)values ('1', 'a');
insert into t_one_many (TCODE, TM)values ('1', 'b');
insert into t_one_many (TCODE, TM)values ('1', 'c');
insert into t_one_many (TCODE, TM)values ('1', 'd');
insert into t_one_many (TCODE, TM)values ('1', 'e');
insert into t_one_many (TCODE, TM)values ('2', 'f');
insert into t_one_many (TCODE, TM)values ('2', 'g');
insert into t_one_many (TCODE, TM)values ('2', 'h');
insert into t_one_many (TCODE, TM)values ('2', 'i');
insert into t_one_many (TCODE, TM)values ('2', 'j');
insert into t_one_many (TCODE, TM)values ('3', 'k');
insert into t_one_many (TCODE, TM)values ('3', 'l');
insert into t_one_many (TCODE, TM)values ('3', 'm');
insert into t_one_many (TCODE, TM)values ('3', 'n');
insert into t_one_many (TCODE, TM)values ('3', 'o');
with a1 as
(select t.tcode, t.tm from t_one_many t)
select tcode,wm_concat(tm) from a1 group by tcode;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769592/ ，如需转载，请注明出处，否则将追究法律责任。
