oracle批量新增并更新

MERGE INTO bonuses D
USING (SELECT employee_id, salary, department_id FROM employees
   WHERE department_id = 80) S
   ON (D.employee_id = S.employee_id)
   WHEN MATCHED THEN UPDATE SET D.bonus = D.bonus + S.salary*.01
     DELETE WHERE (S.salary > 8000)
   WHEN NOT MATCHED THEN INSERT (D.employee_id, D.bonus)
     VALUES (S.employee_id, S.salary*.01)
     WHERE (S.salary <= 8000);

mybatis 下：

<!--批量插入，若存在则更新-->
	<insert id="insertOrUpdateBatch">
		MERGE INTO T_ITEMS_REGI_XATTRS t1
		USING (
		<foreach collection="list" item="item" index="index" separator="union" >
			select
			#{item.item_id,jdbcType=BIGINT} item_id,
			#{item.xattrs_code,jdbcType=VARCHAR} xattrs_code,
			#{item.xattrs_value,jdbcType=VARCHAR} xattrs_value,
			#{item.creator,jdbcType=VARCHAR} creator,
			#{item.create_date,jdbcType=TIMESTAMP} create_date,
			#{item.create_ip,jdbcType=VARCHAR} create_ip
			from dual
		</foreach>) t2
		ON (
		t1.item_id =  t2.item_id
		AND t1.xattrs_code = t2.xattrs_code
		)
		WHEN MATCHED THEN
		UPDATE SET t1.xattrs_value = t2.xattrs_value,t1.updator = t2.creator,t1.update_date=sysdate,t1.update_ip=t2.create_ip
		WHEN NOT MATCHED THEN
		INSERT
		(XATTRS_ID,item_id, xattrs_code, xattrs_value, creator, create_date, create_ip)
		VALUES
		(SEQ_id.NEXTVAL,t2.item_id, t2.xattrs_code, t2.xattrs_value, t2.creator, sysdate, t2.create_ip)
	</insert>