How do I update SQL statements for column data between oracle tables ?, Oraclesql

How do I update SQL statements for column data between oracle tables ?, Oraclesql

Table A (id, name, age, home_adders, phone_number) and Table B (id, name, adders, number, the two tables have two fields with the same id and name, and can uniquely identify A row. Update the adders and number information in table B to the home_adders and phone_number fields in Table A. The statement is as follows:

Update A a SET (. home_adders,. phone_number) = (select B. adders, B. number from B B where. id = B. id and. name = B. name );