Re: ORA-00928: missing SELECT keyword

I've got VALUES in there...my query looks like this

INSERT INTO flasher (date) VALUES ('05-FEB-2003');

Then the server replies with the error.  It's definitely got me
confused!

					Tom


[email protected] wrote:
> 
> send the insert statement
> but youre probably missing the VALUES keyword.
> 
> Regards
> Chris Farmer
> 
> 
> 
> I have come up to a strange problem which I can't figure out.  I have a
> table which holds details of rental barricades.  I have set most of the
> fields to accept NULL values for testing.  The only required field at
> this point is the Date.  When I try to insert a record (using SQL Plus,
> 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 an INSERT.  I've searched the web briefly, but can't find
> any info.  Thanks in advance for your help.
> 
> ==============================
> Tom Skillman
> Programmer/Analyst I
> City of St. Louis Water Division
> 
> [email protected]
> (314) 771-4806  ext 184
>

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].