ORA-00936: 缺少表达式 求大神解答

Question

INSERT INTO MESSAGE
(APPROVAL_NUMBER,HEADLINE,APPROVAL_STATUS,APPROVAL_RESULT,JOB_NUMBER,OVER_USERID

         )
        SELECT majorKey.NEXTVAL MESSAGE_ID, A.*
        FROM(
        <foreach collection="list" item="item" index="index" separator="UNION ALL">
         SELECT     #{item.approvalNumber,jdbcType=VARCHAR} APPROVAL_NUMBER,#{item.headline,jdbcType=VARCHAR} HEADLINE,#{item.approvalStatus,jdbcType=VARCHAR} APPROVAL_STATUS,#{item.approvalResult,jdbcType=VARCHAR} APPROVAL_RESULT,#{item.jobNumber,jdbcType=VARCHAR} JOB_NUMBER,#{item.overUserid,jdbcType=VARCHAR} OVER_USERID,

             FROM dual
           </foreach>

Answer 1

如何你是想批量新增

 insert into 表名

       <foreach collection="list" item="item" index="index"  open="("  close=")"  separator="union all">

            select #{item.字段1},

                       #{item.字段2}

                      from dual

    </foreach>