每秒循环插入数据

create tablespace TEST datafile 'C:\ORACLE\ORADATA\ORCL\TEST01.DBF' size 100M autoextend on;create user TEST identified by test default tablespace TEST;grant connect,resource,create view to TEST;

create table TEST.test2(id number(20),sj date,sj2 date,sj3 date,sj4 date);

create sequence test_seqminvalue 1maxvalue 100000start with 1increment by 1cache 20;

declaremaxrecords constant int:=100000;i int :=1;beginfor i in 1..maxrecords loopinsert into TEST.test2values(test_seq.nextval,sysdate,sysdate,sysdate,sysdate);commit;dbms_lock.sleep(1);end loop;end;/