天天看点

oracle插数据语句,Oracle同时插入多条数据修正语句

网址58~80行,正确语句

INSERT ALL

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S1','P1','J1',200)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S1','P1','J3',100)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S1','P1','J4',700)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S1','P2','J2',100)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S2','P3','J1',400)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S2','P3','J2',200)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S2','P3','J4',500)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S2','P3','J5',400)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S2','P5','J1',400)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S2','P5','J2',100)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S3','P1','J1',200)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S3','P3','J1',200)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S4','P5','J1',100)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S4','P6','J3',300)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S4','P6','J4',200)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S5','P2','J4',100)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S5','P3','J1',200)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S5','P6','J2',200)

INTO SPJ (SNO,PNO,JNO,QTY) VALUES ('S5','P6','J4',500)

SELECT 1 FROM DUAL;