Oracle statement for batch update or database insertion

Oracle statement for batch update or database insertion

1. oracle batch update or database insertion statement:

<Foreach collection = "orderWarehousePos" item = "orderWarehousePo" open = "begin" close = "end;"> UPDATE orderWarehouse SET shippingCompanyid = # {orderWarehousePo. shippingCompanyId}, CUSTOMERSHIPPINGACC =#{ orderWarehousePo. customerShippingAcc}, approvedShippingTotal =#{ orderWarehousePo. approvedShippingTotal}, update_By =#{ orderWarehousePo. updateBy}, UPDATE_DATE =#{ orderWarehousePo. updateDate} WHERE orderWhId = # {orderWarehousePo. orderWhId };

 Foreach>

To operate databases in batches, you must add the begin end statement. The last update must end with a semicolon.

Multiple set fields in the update statement must be separated by commas.