1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
create table tmp (n number(32), n2 number(32), n3 number(32), n4 number(32), n5 number(32)) pctfree 20;
insert into tmp (n) select to_number(lpad(level,25,1)) from dual connect by level<1e4;
create table results as select '00' as step, sum(blocks) as number_blocks from user_segments where segment_name='TMP';
update tmp set (N2,n3)=(select to_number(lpad(1,31,1)),to_number(lpad(2,31,1)) from dual);
insert into results select '01',sum(blocks) from user_segments where segment_name='TMP';
update tmp set (n4,n5)=(select to_number(lpad(3,31,1)),to_number(lpad(4,31,1)) from dual);
insert into results select '02',sum(blocks) from user_segments where segment_name='TMP';
select * from results;
STEP NUMBER_BLOCKS
----- ------------
00 40
01 256
02 256 |
Partager