loop row_count := 1; insert into table1... select * from table2 where rownum< row_count*100; commit; row_count := row_count+1; end loop; 大致就这么个意思,没调试过,语法肯定有错。
declare row_count number(3):=0; Begin for row_count in 1..n Loop insert into test_Back select * from test where rownum< row_count*10; commit; row_count := row_count+1; end loop; End;为什么老是出错这语句???????????????????
row_count := 1;
insert into table1...
select * from table2 where rownum< row_count*100;
commit;
row_count := row_count+1;
end loop;
大致就这么个意思,没调试过,语法肯定有错。
row_count number(3):=0;
Begin
for row_count in 1..n Loop
insert into test_Back
select * from test where rownum< row_count*10;
commit;
row_count := row_count+1;
end loop;
End;为什么老是出错这语句???????????????????