Oracle SQL update based on subquery between two tables .... You can use merge. MERGE INTO ...
stackoverflow.com