UPDATE Batch operation with MYBATIS ORACLE enviorment

865 views Asked by At

I am able to insert many rows in single database call in MyBatis.
Below is my query -

<insert id="insert" parameterType="map">
          INSERT ALL
            <foreach collection="list" item="item" index="index" >
                 INTO TABLE(FIELD1,FIELD2) values
                 (#{item.field1},#{item.field2})
            </foreach>
          SELECT * FROM dual
</insert>

I want to do same batch opertaion with UPDATE also.

0

There are 0 answers