批量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

 

posted @ 2018-10-29 08:44  youguess  阅读(168)  评论(0)  编辑  收藏  举报