mybatis操作oracle数据库批量插入写法

<insert id="batchInsert" parameterType="java.util.List">
     insert into uf_sgpt_camera_info
    (
      camera_id,camera_type,create_time,decodetag,description,
      index_code,is_online,latitude,longitude,name,
      parent_index_code,pixel,update_time
    )
    <foreach close=")" collection="list" item="item" open="(" separator="union all">
        select
        #{item.cameraId},
        #{item.cameraType},
        #{item.createTime},
        #{item.decodetag},
        #{item.description},
        #{item.indexCode},
        #{item.isOnline},
        #{item.latitude},
        #{item.longitude},
        #{item.name},
        #{item.parentIndexCode},
        #{item.pixel},
        #{item.updateTime}
        from dual
    </foreach>
</insert>