drop table test
/
drop sequence testSeq
/
create table test(n1 number(6),v1 varchar2(1000)) 
 TABLESPACE "USERS"
/
create sequence testSeq
/
create or replace procedure va(su number)
 as
 begin
    for i in 1..su loop
            insert into test values(testSeq.nextval,'dkfjdkadfasdfdsafsdafdfsfasdfsdafsdafdsafasdfsdafsadfsdfdsfdsfsdafsdafsdasdfasdsafasdfasdf');
            commit;
    end loop;
    commit;

end;
/

exec va(50000)
/
select * from test
/

이 게시물을..