Oracle同时插入多条数据
INSERT ALL
INTO 表名(NAME) VALUES ('tony')
INTO 表名(NAME) VALUES ('tony2')
INTO 表名(NAME) VALUES ('tony3')
SELECT * FROM DUAL;
不能去掉
SELECT * FROM DUAL;
INSERT ALL
INTO 表名(NAME) VALUES ('tony')
INTO 表名(NAME) VALUES ('tony2')
INTO 表名(NAME) VALUES ('tony3')
SELECT * FROM DUAL;
不能去掉
SELECT * FROM DUAL;