ORA-01767: UPDATE … SET expression must be a subquery

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/