Oracle 批量新增语句

mybatis

insert into SYS_RULE(
			ID,
			BUSINESS_TYPE,
			CREATE_INSTRUCT,
			STATUS,
			BANK_CODE,
			DATA_VERSION
		) 
		<foreach collection ="list" item="rule" separator ="union all">
		(
			select
			#{rule.id},
			#{rule.businessType},
			#{rule.createInstruct},
			#{rule.status},
			#{rule.bankCode},
			#{rule.dataVersion}
			from dual
		)
		</foreach>