Re: ORA-00928: missing SELECT keyword

youre going to have to put flasher(date) in double quotes
like this

      insert into flasher("date") values ( '12-dec-20')



Regards
Chris Farmer



                                                                                
                     
                      Tom Skillman                                              
                     
                      <tskillman@stlwat        To:       "Oracle" 
<oracle@xxxxxxxxxxxx>              
                      er.com>                  cc:                              
                     
                                               Subject:  [oracle] Re: 
ORA-00928: missing SELECT      
                      18/02/2003 15:58          keyword                         
                     
                      Please respond to                                         
                     
                      "Oracle"                                                  
                     
                                                                                
                     
                                                                                
                     




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


c.r.farmer@xxxxxxxxxxxxxxxx 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
>
> tskillman@xxxxxxxxxxxx
> (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.unsub%%.






---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to leave-oracle-1796914O@xxxxxxxxxxxxx