Stepwise-Lab

ORA-01407: Cannot update to NULL

An UPDATE would set a NOT NULL column to NULL, for example from a subquery that returns no row.

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