Updating Table Columns Based on Cartesian Product Between Two Temporary Tables Using SQL

Understanding Oracle's UPDATE Table Quirk: How to Update Non-Key-Preserved Tables