oracle中批量插入新增

在sql编辑器中

# 注意字段必须用单引号' ' ,UNION 进行连接
INSERT INTO ZFXT_TASK_LOCK (COORDINATION_ID) 
SELECT 'ad' FROM dual UNION 
SELECT 'fg' FROM dual

注意字段必须用单引号' '

在mybatis中：

insert into ZFXT_TASK_LEGAL_PAPER
        (P_ID,TASK_ID, DOCUMENT_NUMBER)
        <foreach collection="zfxtTaskLegalPaperDOS" item="item" separator="union">
            select #{item.pId},#{item.taskId}, #{item.documentNumber,jdbcType=VARCHAR},
             from dual
        </foreach>