In an Oracle database, the way to update another table with one table

In Oracle, there are times when you need to update another table with one table. The following are examples of implementations:

1. Create a table test_a

CREATE TABLE Test_a (
ID Number (19),
Name VARCHAR2 (20),
Age Number (3)
)

2. Insert some data yourself

3. Create a table with the same structure as Test_a Test_b

CREATE TABLE Test_b as
SELECT * from Test_a;

4. Then make some modifications to the TEST_B data to ensure that the ID value is at least one of the same as the Test_a ID value

SELECT * from Test_b for update;
Update Test_b set age=age+1;

5 finally update test_a table with Test_b table

Update Test_a a set (a.name,a.age) =
(select B.name,b.age from Test_b b where a.id = b.id) where exists
(SELECT * from Test_b C where c.id=a.id)