在ORACLE中,如何一次插入多条记录(数组中的数据)

[cnzyg]

以前学过这种SQL:
INSERT INTO S(A,B,C)
VALUES(0,'B1','C'),
(1,'B2','C2')
.
.
可以一次插入多条,可现在我在PL/SQL中写这语句时,总报SQL不能正常终了,请问如何才能一次将变体数组中的多条一次插入呢

[drabit]

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;

[jiangchuanli]

我只知道
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;
/

[lianhg]

不可能的

[baojianjun]

我暫時不知道

[dclssczg]

insert into tab(field...) select ...
行不?

[liuyi8903]

up一下。

[beckhambobo]

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;
/

[zwbbj]

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

[flymoon]

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