Re: ORA-00928 Error

From: Kelly Conboy <conboyka_at_thc-tsg.com>
Date: Wed, 26 Sep 2001 14:28:12 -0400
Message-ID: <9ot6pf$3po$1_at_bob.news.rcn.net>


Here is more explanation as to what the error means:

ORA-00928 missing SELECT keyword

Cause: A SELECT subquery must be included in a CREATE VIEW statement.

Action: Correct the syntax. Insert the required SELECT clause after the CREATE VIEW clause and then retry the statement.

You can get to any Oracle error explanations by going to http://technet.oracle.com/ and registering. The page on this site where I found the error message explanation is:

http://technet.oracle.com/doc/server.815/a67785/e900.htm

This link will only work if you have a login (userid/password) when you registered with Oracle's technet.

Kelly Conboy

"Jim Rajan" <ajvrajan_at_ntu.edu.sg> wrote in message news:40416010.0109251923.1a29f6d5_at_posting.google.com...
> I am getting the following error message when I try to Insert a Record
> in Oracle Forms 6.08. I check the Display Error option and it says
> ORA-00928:Missing Select Keyword. Please help, need to finish this
> urgently.
Received on Wed Sep 26 2001 - 20:28:12 CEST

Original text of this message