有些时候我们使用sql批量新增会使用到union all拼接好数据后新增,如下:
INSERT INTO TABLE_NAME
(SELECT SEQ.NEXTVAL SEQ, 1 A, 100006969 B, 1 C, 'sort' D FROM DUAL
UNION ALL
SELECT SEQ.NEXTVAL SEQ, 1, 100006969, 1, 'SORT' FROM DUAL)
结果发现语法错误了,查看文档果然也是不允许的,所以你可以尝试如下方式:
INSERT INTO TABLE_NAME
(SELECT SEQ.NEXTVAL SEQ, T.*
FROM (SELECT 1 A, 100006969 B, 1 C, 'sort' D FROM DUAL
UNION ALL
SELECT 1, 100006969, 1, 'SORT' FROM DUAL)) T