ORA-00926: missing VALUES keyword

ORA-00926: missing VALUES keyword

ORA-00926: missing VALUES keyword

Cause:

An INSERT statement has been entered without the keyword VALUES or SELECT.

Solution:

Correct the syntax. Enter either a VALUES clause or a subquery after the INSERT INTO clause.




Example:

Insert into BOOKS (ID,NAME,PRICE) 
val (2,'MySQL Tutorial',32);

Output:

ORA-00926: missing VALUES keyword

Correct

Insert into BOOKS (ID,NAME,PRICE) 
values (2,'MySQL Tutorial',32);

Output:

1 rows inserted.