PROMPT Creating table INTERIM_FLIGHT

CREATE GLOBAL TEMPORARY TABLE INTERIM_FLIGHT ( 
  FLIGHT_ID                  NUMBER(10),
  FLIGHT_NO                  CHAR (8), 
  FLIGHT_DATE                CHAR (5), 
  SITE_ID                    NUMBER (10),
  SCHEDULED_TIME             CHAR (4),
  CARRIER_ALPHA_CODE         CHAR (3),
  DEPARTURE_TIME             DATE )
ON COMMIT DELETE ROWS;
