Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

INSERT rows for 60 seconds and then COMMIT

JOE_humbleOct 31 2017 — edited Nov 1 2017

DB version: 11.2.0.4

I have a table and a sequence like below.

create table t (t_id number , t_c2 varchar2(35) );

create sequence t_id_generator

minvalue 1

maxvalue 9999999999

start with 1

increment by 1

cache 100

noorder

nocycle;

I want to run the below INSERT statement in a loop for 1 minute and then COMMIT. Any idea how I can do this ?

insert into t values (t_id_generator.nextval, 'a');

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2017
Added on Oct 31 2017
21 comments
3,093 views