Add fields in Oracle and then update statements in batches

Oracle adds fields and then updates the statement in batches. This business requirement is: a new field is added to t_bnet_customer in an old table. This field is included in t_customer_extend in another table, the original statement: www.2cto.com UPDATE t_bnet_customer a SET. customer_id = (SELECT B. cust_nbr FROM t_customer_extend B WHERE. id = B. bnet_id) where exists (SELECT B. cust_nbr FROM t_customer_extend B WHERE. id = B. bnet_id) subsequent statement: update (select. customer_id a1, B. cust_nbr b1 from t_bnet_customer a, t_customer_extend B where. id = B. bnet_id) set a1 = b1; the statement above www.2cto.com is restricted by oracle. If it cannot be executed, replace it with the following: update (select/* + BYPASS_UJVC */. customer_id a1, B. cust_nbr b1 from t_bnet_customer a, t_customer_extend B where. id = B. bnet_id) set a1 = b1;