create table test(
t_id char(5) not null,
t_name varchar2(8) not null,
constraint pk_test primary key(t_id)
);
set timing on;
declare i integer;
begin i:=1;
loop insert into test(t_id, t_name) values(SEQ_TEST.nextval, 'xxx');
i:=i+1;
exit when i>100000;
end loop;
commit;
end;
Oracle 插入测试
最新推荐文章于 2021-04-05 08:07:24 发布