Shulou(Shulou.com)06/01 Report--

Method 1 (recommended):

UPDATE Table 2 SET Table 2.C = (SELECT B FROM Table 1 WHERE Table 1.A = Table 2.A) WHERE EXISTS (SELECT 1 FROM Table 1 WHERE Table 1.A = Table 2.A)

It is particularly important to pay particular attention to the last outer where condition, which is to lock the scope of its batch update data.

Method 2:

MERGE INTO Table 2 USING Table 1 ON (Table 2.A = Table 1.A)-- if An is the same WHEN MATCHEDTHEN UPDATE SET Table 2.C = Table 1.B-when matching, update

The above is the Oracle two tables introduced by the editor to update the data of one of the tables in batches. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.