Stepwise-Lab

ORA-01735: Invalid ALTER TABLE option

The ALTER TABLE syntax is not Oracle's: for example ALTER COLUMN (use MODIFY), or SET NOT NULL (use MODIFY col NOT NULL).

On the exam

This error belongs to the topic Tables and constraints 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