Example on how to update field with corelated select subquery in Oracle database

Here is an example that would update a column based on the value in another table.