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');