Alternate Oracle ORDERS TABLE INSERT STATEMENTS

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (1, 'D1002', TO_DATE ('11-NOV-1999', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D1002', TO_DATE ('15-MAR-1998', 'DD-MON-YYYY'), TO_DATE ('30-MAR-2001', 'DD-MON-YYYY');

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D1003', TO_DATE ('15-MAR-1998', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D2202', TO_DATE ('01-JAN-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'W1001', TO_DATE ('15-MAR-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'L2003', TO_DATE ('15-MAR-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'I1001', TO_DATE ('20-MAR-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (3, 'L2002', TO_DATE ('10-JUL-2000', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (3, 'L2001', TO_DATE ('10-JUL-2000', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (4, 'L2004', TO_DATE ('15-FEB-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (7, 'L2004', TO_DATE ('14-MAY-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'D1002', TO_DATE ('04-NOV-2000', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'D1101', TO_DATE ('04-NOV-2000', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (5, 'I1001', TO_DATE ('06-JUN-1999', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'I1001', TO_DATE ('14-MAR-1999', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'I1001', TO_DATE ('04-NOV-2000', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (7, 'L2001', TO_DATE ('13-MAY-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (4, 'L2001', TO_DATE ('15-FEB-2001', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'L2001', TO_DATE ('17-MAR-1999', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'L2002', TO_DATE ('17-MAR-1999', 'DD-MON-YYYY'), NULL);

INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (9, 'L2003', TO_DATE ('11-JUN-2000', 'DD-MON-YYYY'), NULL);

back