Why do I keep getting this error message ORA-00928: missing SELECT keyword?

ora-00928: missing select keyword with clause
ora-00928: missing select keyword update
ora-00928 missing select keyword insert all
java.sql.sqlsyntaxerrorexception: ora-00928: missing select keyword

Why do I keep getting this error message

ORA-00928: missing SELECT keyword

This is the query I have...

INSERT ALL
INTO ACADEMIC_SESSION (SESSIONID, SESSIONNAME) VALUES (200, 'FALL SESSION'),
INTO ACADEMIC_SESSION (SESSIONID, SESSIONNAME) VALUES (300, 'SUMMER SESSION')
SELECT * from DUAL;

I can't see what is wrong with it.

Wrong syntax; use one of these:

SQL> create table academic_session
  2    (session_id number,
  3     session_name varchar2(20));

Table created.

SQL> insert into academic_session (session_id, session_name)
  2  select 200, 'fall session' from dual union all
  3  select 300, 'summer session' from dual;

2 rows created.

SQL> insert all
  2    into academic_session (session_id, session_name)
  3      values (400, 'spring session')
  4    into academic_session (session_id, session_name)
  5      values (500, 'winter session')
  6  select * from dual;

2 rows created.

SQL>

ORA--00928 missing SELECT keyword, I am entering this code into ORACLE 11, SQL Plus: WITH testingit1 AS (SELECT incollection, ERROR at line 3: ORA--00928 missing SELECT keyword Any idea on why i'm getting this error message? From where is the  Hi, Please do not post the same question in multiple newsgroups. Please see my reply in the other group. thanks. more

There is no comma , between the INTO statements

INSERT ALL
INTO ACADEMIC_SESSION (SESSIONID, SESSIONNAME) VALUES (200, 'FALL SESSION')
INTO ACADEMIC_SESSION (SESSIONID, SESSIONNAME) VALUES (300, 'SUMMER SESSION')
SELECT * from DUAL;

Oracle / PLSQL: ORA-00928 Error Message, Learn the cause and how to resolve the ORA-00928 error message in Oracle. You tried to create an Oracle VIEW, but missed the SELECT keyword. This website would not exist without the advertisements we display and your kind donations. If you are unable to will appear: ORA-00928: missing SELECT keyword  ORA-00928: missing SELECT keyword Can any one help me with this situation? why is this happening? Thanks in advance Sunny <HR></BLOCKQUOTE> null Like Show 0 Likes (0)

If you need to insert two rows into the table, you may do so like this:

INSERT INTO ACADEMIC_SESSION (SESSIONID, SESSIONNAME) 
VALUES (200, 'FALL SESSION'), (300, 'SUMMER SESSION');

Hope this helps.

ORA-00928: missing SELECT keyword, Error Message - DMS-E-GENERAL, A general exception has occurred ORA-​00928: missing SELECT keyword Solution: The user was going Neither the Database version nor the Client piece are supported in Series 7. Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

how to solve missing select keyword, Can someone know what wrong with my code below? I trying to insert but keep showing error ora-00928 missing select keyword ? I did online  Did you find this information helpful? Yes No. Mar 26, 2020

ORA-00928: missing SELECT keyword, my PHP code, or the DBA Studio), I get an error ORA-00928: missing. SELECT keyword. I can't figure out why it's wanting a select statement when I'm doing it looks like you could be in for a whole world of pain if you keep with this. Regards (arraysize is 15) Will commit when done. (copycommit is 0) Maximum long size is 80. (long is 80) ERROR: ORA-00928: missing SELECT keyword SQL> copy to a/a@orcl - > insert b.test - > using - > select * from b.test where product_cd = 'CNDIV' and portfolio_id = 'TEST' Array fetch/bind size is 15. (arraysize is 15) Will commit when done.

ORA 00928: missing Select keyword., I'm having all kinds of problems with the missing or not valid error option with the following function. Why I get this message and how do I stop it? ORA-00936 missing expression. Cause: A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression.

Comments
  • What do you want to insert to the table? Why do you need the select statement?
  • @TeeKea, the select is required for this type of "insert all" statement.
  • Ok, that works! The last syntax you gave me looks exactly like mine, what am I missing?
  • You aren't missing anything; you have a comma (between two INSERTs) too much :)
  • I've tried this as well. I actually copied and pasted what you wrote and got this error message ORA-00933: SQL command not properly ended. It allows me to insert one row, but I have multiple rows and that will take forever.