Cause
An attempt was made to use a single expression without a subquery to update a list of columns.
Action
Check the syntax for using subqueries to update data and add the necessary subquery.
Oracle 26ai
ORA-01767
Error Message
UPDATE ... SET expression must be a subquery