Stepwise-Lab

ORA-38104: Columns referenced in the ON clause cannot be updated

MERGE cannot update the columns used to match rows in its ON clause.

On the exam

This error belongs to the topic DML and transactions of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors