建立一个insert的存储过程!!
create or replace procedure myj_insert as
i number;
begin
i:=1;
for i in 1..10000 (循环1W次!!可以自己定义循环的次数)
loop
Insert into YOUR_TABLENAME
(ID, CATE_ID, RESOURCE_NAME,DESCRIPTION,OWNER_ID,IS_AUDIT,DOWNLOAD_TIMES, CREATE_TIME, MODIFY_TIME,FLAG, RESOURCE_MARK, RESOURCE_LENGTH, DOWNLOAD_MARK)
Values
(resource_seq.nextval, 0, 'MOVIE', 'filme', 1+i, 'N', 0+1, TO_DATE('08/31/2007 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('08/12/2007 10:56:26', 'MM/DD/YYYY HH24:MI:SS'),'N',20+i,10+i,0+i);
commit;
end loop;
dbms_output.put_line(1111111);
end myj_insert;
/
里面的代码可以做修改!!!!
运行存储过程!
declare
begin
myj_insert;
end;
OK!自己到数据库查去!!!