在Oracle中，您不能像这样指定多组值（我猜您来自允许该语法的MySQL背景）。最简单的方法是生成多个
INSERT语句
INSERT INTO works_on(essn, pno, hours)values('123456789', 1, 32.5);INSERT INTO works_on(essn, pno, hours)values('123456789', 2, 7.5);INSERT INTO works_on(essn, pno, hours)values('666884444', 3, 40.0);...您还可以使用单个
INSERT ALL语句插入多行
INSERT ALL INTO works_on(essn, pno, hours) values('123456789', 1, 32.5) INTO works_on(essn, pno, hours) values('123456789', 2, 7.5) INTO works_on(essn, pno, hours) values('666884444', 3, 40.0) INTO works_on(essn, pno, hours) values('453453453', 1, 20.0) INTO works_on(essn, pno, hours) values('453453453', 2, 20.0) INTO works_on(essn, pno, hours) values('333445555', 2, 10.0) INTO works_on(essn, pno, hours) values('333445555', 3, 10.0) ...SELECt * FROM dual;
