oracle中的insert all写法

INSERT ALL 
  <foreach collection="list" item="map">
   INTO FG_ESTABLISHACCOUNT_DETAILS
   <trim prefix="(" suffix=")" suffixOverrides=",">
    DOCUMENT_NO,
    DOCUMENT_ITEM,
   </trim>
   VALUES
   <trim prefix="(" suffix=")" suffixOverrides=",">
    #{map.DOCUMENT_NO},
    #{map.DOCUMENT_ITEM},
   </trim>
  </foreach>
  SELECT 1 FROM DUAL
posted @ 2020-01-01 15:13  四块五  阅读(639)  评论(0编辑  收藏  举报