UPDATE Statement - Oracle Documentation

PL/SQL User's Guide and Reference ... Then it runs an UPDATE statement with a correlated query, to retrieve the correct names from the EMPLOYEES table and fix the names in the new ...

docs.oracle.com