insert into wlbtest1 values ('a', 1);

insert into wlbtest1 values ('b', 1);
insert into wlbtest1 values ('d', 2);
deptName varchar2(10),

);
insert into wlbtest1 values ('c', 1);
);
insert into wlbtest1 values ('f', 2);

执行结果：

复制代码 代码如下:

username varchar2(2),
deptID number
insert into wlbtest1 values ('e', 2);
create table wlbtest2(

insert into wlbtest2 values ( '部门2', 2);
insert into wlbtest2 values ( '部门1' ,1);
create table wlbtest1(
select deptID, wm_concat(username) username,'部门'||deptID deptName from wlbtest1 group by deptID
deptID number