|
create table RBC (
C_NUM number,
B_NUM number)
pctfree 20
pctused 60
tablespace rbc_test
storage ( initial 100
next 100
pctincrease 10 );
create or replace procedure rbc_test_pr is
begin
for i in 1..100000 loop
insert into RBC values (i, i);
commit;
end loop;
end;
/
execute rbc_test_pr
select count(*) from rbc;
|