Issue: Modification between Oracle two tables; results: an implementation of updates between Oracle two tables

Prerequisites:

Field ID and name in table Info_user, field ID is indexed

Field ID and name in table Data_user_info, field ID is indexed

The field ID in table Info_user is the same as the field ID value in table data_user_info.

Required implementations:

The field name in Update table Info_user is the same as the field name in Table Data_user_info.

The SQL statements implemented are:

Update Info_user I set (i.name) = (select D.name from Data_user_info d where d.id = I.id)

where i.id = (select D.id from Data_user_info d where d.id = I.id);

Commit

Issue: Modification between Oracle two tables; results: an implementation of updates between Oracle two tables