ORA-00928: missing SELECT keyword when inserting data [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

I am trying to insert da开发者_开发问答ta into database but I am getting this exception:

java.sql.SqlException:[Oracle][ODBC]ORA-00928:missing SELECT keyword

---

It sounds like you're trying to insert data into an Oracle table. Try formulating a statement like this:

 INSERT INTO MyTable(Column1, Column2)
 VALUES (1, 'SomeString');

or

INSERT INTO MyTable(Column1, Column2)
     SELECT Foo, Bar
     From MySecondTable;