Oracle批量插入语句

直接上代码

单表批量插入

INSERT INTO TEST(NO)
(
	SELECT '123' FROM dual UNION ALL
	SELECT '324' FROM dual UNION ALL
	SELECT '544' FROM dual UNION ALL
	SELECT '455' FROM dual
);

多表批量插入

--批量插入不同的表
INSERT ALL
INTO TEST1(NO)
VALUES('4312356')
INTO TEST2(NO)
VALUES('42123356')
INTO TEST3(NO)
VALUES('43512346')
SELECT * FROM dual