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.
