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>