<update id="checkPreJobPlan" parameterType="java.util.List" databaseId="oracle"> BEGIN <foreach collection="eduCourse.courseMembers" item="member" separator=";"> update numas_employee_train_record set audit_status = #{member.auditStatus} where course_id = #{eduCourse.id} and employee_id = (select id from numas_employee_archive where code = #{member.code}) </foreach> ;end; </update>
oracle 批量更新
最新推荐文章于 2022-07-11 16:01:48 发布