oracle批量修改多条,oracle 在xml中批量插入，批量修改及多组条件查询

into notification_push_info(

push_log_no,

business_book,

employee_id,

notification_no,

push_flag,

push_time

)values

(

bep_seq_package.fetch_seq('NOTIFICATION_PUSH_INFO','PUSH_LOG_NO','BEPDATA'),

#list[].businessBook:varchar#,

#list[].employeeId:varchar#,

#list[].notificationNo:varchar#,

#list[].pushFlag:varchar#,

sysdate

)

select distinct employee_id "employeeId",

notification_no "notificationNo"

from notification_push_info npi

where npi.invalid_flag = 'N'npi.employee_id = #notiList[].employeeId#

and npi.business_book = #notiList[].businessBook#

and npi.notification_no = #notiList[].notificationNo#

beginupdate notification_push_info set

push_flag = #list[].FLAG#,

push_time = sysdate

where invalid_flag = 'N'

and employee_id = #list[].employeeId#

and notification_no = #notiList[].notificationNo#;end;