create table num (id int);
begin
for i in 1…100 loop
insert into num values(i);
end loop;
commit;
end;
/
select * from num;
with t as
(select level id from dual connect by level<=100),
s as (select id,rownum rn from num order by id)
select wm_concat(id) from s group by ceil(rn/2);
create table num (id int);
begin
for i in 1…100 loop
insert into num values(i);
end loop;
commit;
end;
/
select * from num;
with t as
(select level id from dual connect by level<=100),
s as (select id,rownum rn from num order by id)
select wm_concat(id) from s group by ceil(rn/2);