title: Multiple Insert statement failing ORA-00905: missing keyword error
body: <p>I am using the below SQL script to insert few records into a new table that I created using create statement. But I am getting the following error</p>
  
  <blockquote>
    <p>ORA-00905: missing keyword</p>
  </blockquote>
  
  <p>Below is the script which is quite straightforward. I guess I am missing something. FYI, I have tested with both <code>;</code> at the end and without <code>;</code> but it yields the same result. </p>
  
  <p>Any idea what I am missing here?</p>
  
  <pre><code>create table winlossbydate1 (
  statusdate Date,
  Status     Char(5));
  
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-01','yyyy-mm-dd'), 'win'); 
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-01','yyyy-mm-dd'), 'lose');
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-01','yyyy-mm-dd'), 'lose');
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-01','yyyy-mm-dd'), 'lose');
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-01','yyyy-mm-dd'), 'win');
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-02','yyyy-mm-dd'), 'lose');
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-02','yyyy-mm-dd'), 'win');
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-02','yyyy-mm-dd'), 'win');
  Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE('2011-03-02','yyyy-mm-dd'), 'win')
  </code></pre>