ORA-00925: missing INTO keyword

ORA-00925: missing INTO keyword

Oracle PL/SQL error message: ORA-00925: missing INTO keyword.

Cause:

The INSERT statement has been entered without the keyword INTO.

Solution:

On the INSERT statement add the keyword INTO and then retry the statement.




Example:

Insert  COURSE (COURSE_ID,NAME,DESCRIPTION,DURATION,PRICE) 
values (6,'Java','Java course 1','12 weeks',200);

Output:

ORA-00925: missing INTO keyword

Correct:

Insert INTO COURSE (COURSE_ID,NAME,DESCRIPTION,DURATION,PRICE) 
values (6,'Java','Java course 1','12 weeks',200);

Output:

1 rows inserted.