ORA-00971: missing SET keyword

ORA-00971: missing SET keyword

Oracle PL/SQL error message: ORA-00971: missing SET keyword.

Cause:

The keyword SET in an UPDATE statement is missing, misspelled, or misplaced.

Solution:

Check syntax and spelling, and use the keyword SET after the name of the table to be updated.




Example:

UPDATE students 
ADDRESS='ABC No 1' 
WHERE STUDENT_ID=1;

Output:

ORA-00971: missing SET keyword

Correct:

UPDATE students 
SET ADDRESS='ABC No 1' 
WHERE STUDENT_ID=1;

Output:

1 rows updated.