Oracle数据库批量向表中插入数据
代码如下:
表名:EXCEL
字段:ID,NAME,AGE,SEX
select * from EXCEL t
INSERT INTO EXCEL(ID,NAME,AGE,SEX) VALUES((01, 02, 03, 04),(02, 02, 03, 04))
INSERT INTO EXCEL(ID,NAME,AGE,SEX) VALUES(01,测试,11,男);
INSERT INTO EXCEL(ID,NAME,AGE,SEX) VALUES(01,02,03,04)
两种方法:
一、
-- 可行
begin
insert into EXCEL(ID,NAME,AGE,SEX) values(01,02,03,04);
insert into EXCEL(ID,NAME,AGE,SEX) values(02,02,03,04);
insert into EXCEL(ID,NAME,AGE,SEX) values(03,02,03,04);
end;
二、
-- 可行
insert all
into EXCEL(ID,NAME,AGE,SEX) values(01,02,03,04)
into EXCEL(ID,NAME,AGE,SEX) values(02,02,03,04)
into EXCEL(ID,NAME,AGE,SEX) values(03,02,03,04)