forall例子DECLARE TYPE NumList IS VARRAY(20) OF NUMBER; depts NumList := NumList(10, 30, 70); -- department numbers BEGIN FORALL i IN depts.FIRST..depts.LAST insert into emp(deptno) values(depts(i)); END;
我只知道 INSERT INTO S(A,B,C) VALUES(0,'B1','C') INSERT INTO S(A,B,C) VALUES(1,'B2','C2') ......commit或DECLARE BEGIN FOR I IN 1..500 LOOP insert into table_aa(col_a,col_b) values (I,i||i); COMMIT WORK; END LOOP; END; /
insert into s (a,b,c) select ... from ...; or begin for i in 1..10 loop insert into s (a,b,c) values(...); end loop; end; /
insert all into comfort(city,sample,noon,midnight) values('1','1','1','1') into comfort(city,sample,noon,midnight) values('2','2','2','2') select * from dual
insert all into comfort(city,sample,noon,midnight) values('1','1','1','1') into comfort(city,sample,noon,midnight) values('2','2','2','2') select * from dual
TYPE NumList IS VARRAY(20) OF NUMBER;
depts NumList := NumList(10, 30, 70); -- department numbers
BEGIN
FORALL i IN depts.FIRST..depts.LAST
insert into emp(deptno) values(depts(i));
END;
INSERT INTO S(A,B,C) VALUES(0,'B1','C')
INSERT INTO S(A,B,C) VALUES(1,'B2','C2')
......commit或DECLARE
BEGIN
FOR I IN 1..500 LOOP
insert into table_aa(col_a,col_b) values (I,i||i);
COMMIT WORK;
END LOOP;
END;
/
or
begin
for i in 1..10 loop
insert into s (a,b,c) values(...);
end loop;
end;
/
into comfort(city,sample,noon,midnight)
values('1','1','1','1')
into comfort(city,sample,noon,midnight)
values('2','2','2','2')
select * from dual
into comfort(city,sample,noon,midnight)
values('1','1','1','1')
into comfort(city,sample,noon,midnight)
values('2','2','2','2')
select * from dual