title: Oracle 10g : insert statement with date and varchar2 values (ORA-00911 error)
body: <p>I have created a table in Oracle 10g and trying to insert some rows into the table using insert statements. But I am repeatedly getting the following error:</p>
  
  <pre><code>ORA-00911: invalid character
  </code></pre>
  
  <p>And the insert statements that are giving the ORA-00911 error is as follows:</p>
  
  <pre><code>Insert into WinLossByDate (StatusDate, Status)
          Values (TO_DATE(‘2011-03-01’,‘yyyy-mm-dd’), ‘lose’);
  </code></pre>
  
  <p>N.B.My table definition is as follows</p>
  
  <pre><code> Name                                      Null?    Type
   ----------------------------------------- -------- -------------
  
   STATUSDATE                                NOT NULL DATE
   STATUS                                    NOT NULL VARCHAR2(5)
  </code></pre>
  
  <p>Can somebody help what is the error?</p>