两种解决方案(来源:http :
//appsfr.free.fr/spip.php?article21):
INSERT ALLINTO table (column1, column2)VALUES (value1, value2)INTO table (column1, column2)VALUES (value1, value2)...etc...SELECt * FROM DUAL ;
或者
INSERT INTO table (column1, column2)SELECt value1, value2 FROM DUAL UNIOn ALLSELECt value1, value2 FROM DUAL UNIOn ALL...etc...SELECt value1, value2 FROM DUAL ;



