批量Insert

oracle 

INSERT ALL 
INTO gs_std_qty(id,part_no,standard_qty) VALUES (100,'123',100) 
INTO gs_std_qty(id,part_no,standard_qty) VALUES (101,'234',101) 
INTO gs_std_qty(id,part_no,standard_qty) VALUES (102,'345',102) 
SELECT 1 FROM DUAL
原文地址:https://www.cnblogs.com/youguess/p/9868631.html