-- 有多种写法,这里给你列出一个来 Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as oracle@ORALABSQL> SQL> create table PROD_SERV(serv_id varchar2(20)); Table created SQL> begin 2 for n in 1..9000 loop 3 insert into prod_serv values(n); 4 if mod(n , 50) = 0 then 5 commit; 6 end if; 7 end loop ; 8 end ; 9 / PL/SQL procedure successfully completed SQL> select count(*) as rscount from prod_serv ; RSCOUNT ---------- 9000 SQL> drop table prod_serv purge ; Table droppedSQL>
create table PROD_SERV(serv_id varchar2(20)); begin for n in 1..9000 loop insert into prod_serv values(n); if mod(n , 50) = 0 then commit; end if; end loop ; end ;
-- 有多种写法,这里给你列出一个来
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as oracle@ORALABSQL>
SQL> create table PROD_SERV(serv_id varchar2(20));
Table created
SQL> begin
2 for n in 1..9000 loop
3 insert into prod_serv values(n);
4 if mod(n , 50) = 0 then
5 commit;
6 end if;
7 end loop ;
8 end ;
9 /
PL/SQL procedure successfully completed
SQL> select count(*) as rscount from prod_serv ;
RSCOUNT
----------
9000
SQL> drop table prod_serv purge ;
Table droppedSQL>
begin
for n in 1..9000 loop
insert into prod_serv values(n);
if mod(n , 50) = 0 then
commit;
end if;
end loop ;
end ;
select count(*) as rscount from prod_serv ;
drop table prod_serv purge ;