Oracle Update Statements

There are several methods in Oracle SQL to update records in one table based on the content of another table.

Here, I give some of those methods and some guidance on where they might be most appropriate.

The Basics

Oracle uses a 'correlated subquery' syntax which looks like this:

more ...