title: ORA-00984 Column not allowed here with date in oracle SQL
body: <p>Im inserting values into this table </p>
  
  <pre><code>    CREATE TABLE Flight ( 
      FlightNumber         char(7) primary key,
      ArrivalAirportCode   char(6)   references Airport  (Airport_code),
      DepartureAirportCode char(6)   references Airport  (Airport_code),
      AircraftNumber       varchar2(25) references Aircraft (AircraftNumber),
      ArrivalDate          date,
      ArrivalTime          Varchar2(5),
      DepartureDate        date,
      DepartureTime        varchar2(5)
      ); 
  </code></pre>
  
  <p>and here are the values Im inserting into it </p>
  
  <pre><code>   INSERT INTO FLIGHT values
     ('CA3048',
     'LHR', 
     'EDI',
     'N859E',
     '14-NOV-2014',
     '22:15', 
     '14-NOV-2014', 
     '20:15');
  </code></pre>
  
  <p>And I get the column not allowed here error for the 2nd date I insert, but not the first one. I've tried putting quotes around the date but I just get another error.  </p>