Oracle insert批量插入语法
INSERT ALL
INTO A(field_1,field_2) VALUES (value_1,value_2)
INTO A(field_1,field_2) VALUES (value_3,value_4)
INTO A(field_1,field_2) VALUES (value_5,value_6)
SELECT 1 FROM DUAL;
补充:评论里提到的为什么要加 SELECT 1 FROM DUAL?
官方例子:
INSERT ALL
INTO sales (prod_.
原创
2021-12-21 15:46:52 ·
1602 阅读 ·
0 评论