Mybatis批量插入oracle

Mybatis批量插入oracle的SQL写法与mysql的写法不一样，oracle的写法如下：

<insert id="saveRolePermission" parameterType="java.util.List">
        insert into tbl_sys_role_permission (role_id, permission_id, del_flg)
        <foreach close=")" collection="list" item="item" index="index"
            open="(" separator="union">
            select
            #{item.roleId,jdbcType=VARCHAR},
            #{item.permissionId,jdbcType=VARCHAR},
            #{item.delFlg,jdbcType=VARCHAR}
            from dual
        </foreach>
    </insert>