创建表
create table sjbjsource1(
ID NUMBER(10) NOT NULL PRIMARY KEY,
NAME VARCHAR(50),
time1 timestamp
);
创建存储过程
create or replace procedure insert_sjbj is
i number;begin
i:=0;
loop
i:=i+1;
if i>1000000 then
exit;
end if;
insert into sjbjsource1(id,name,time1) values(i,i,sysdate);
end loop;
end insert_sjbj;
为表创建自增字段
CREATE SEQUENCE sjbjs_sequence
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
NOCACHE;
CREATE TRIGGER "sjbjs_trigger" BEFORE
INSERT ON sjbjsource1 FOR EACH ROW WHEN(new.id is null)
BEGIN
select sjbjs_sequence.nextval into:new.id from dual;
end;