Oracle+mybatis 批量插入xml 写法

<insert id="insertByList" parameterType="java.util.List">
    INSERT INTO NOTICEUSER(
    NOTICEUSERNO,NOTICEUSERID,USERNAME,USERCODE,
    COMNAME,COMCODE,
    ISVIEWANNOUNCEMENT,
    ISDOWNLOAD,
    SUBMITTIME,
    SUBMITUSERCODE,
    SUBMITUSERNAME,
    SUBMITCOMCODE,
    VALIDSTATUS,
    REVERSE1,
    REVERSE2,
    REVERSE3)
    select A.* from (
    <foreach collection="list" item="data" separator="UNION ALL">
       select #{data.noticeuserno},
        #{data.noticeuserid},
        #{data.username},
        #{data.usercode},
        #{data.comname},
        #{data.comcode},
        #{data.isviewannouncement},
        #{data.isdownload},
        #{data.submittime},
        #{data.submitusercode},
        #{data.submitusername},
        #{data.submitcomcode},
        #{data.validstatus},
        #{data.reverse1},
        #{data.reverse2},
        #{data.reverse3}
       from dual
    </foreach> ) A
</insert>

 oracle 和mysql 写法不一样，注意加select 关键字