insert into T1 values(t1,t2,t3,....);insert into T1 select * from T1;
以2的N次方来增加数据
insert into T1 select * from T1;
insert into T1 select * from T1;
insert into T1 select * from T1;
insert into T1 select * from T1;
insert into T1 select * from T1;
以2的N次方来增加数据
insert into T1 select * from T1;
insert into T1 select * from T1;
insert into T1 select * from T1;
insert into T1 select * from T1;
insert into T1 select * from T1;
DECLARE
i number;
BEGIN
FOR i IN 0..1000000 LOOP
INSERT into table_name (col1,col2...) values (.....
end loop;
end;
/
可是速度很慢,一天一夜过去了,十万条记录还没有加到表中(表是存放用户数据的)
用的是oracle数据库,
2现在我又遇到问题了,我写了一个job,可是到了指定的时间没有运行,必须强制运行job 这是怎么回事情那??
// 9i 是隐参 值为 5