Oracle ORDERS TABLE INSERT
STATEMENTS Click here for "Alternate Insert statements" for other versions of Oracle.
INSERT INTO Orders (CustomerID, PlanID, OrderDate,
CancelationDate)
Values (1, 'D1002', '11-NOV-1999', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D1002', '15-MAR-1998', '30-MAR-2001');
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D1003', '15-MAR-1998', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (10, 'D2202', '01-JAN-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'W1001', '15-MAR-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'L2003', '15-MAR-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (2, 'I1001', '20-MAR-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (3, 'L2002', '10-JUL-2000', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (3, 'L2001', '10-JUL-2000', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (4, 'L2004', '15-FEB-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (7, 'L2004', '14-MAY-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'D1002', '04-NOV-2000', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'D1101', '04-NOV-2000', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (5, 'I1001', '06-JUN-1999', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'I1001', '14-MAR-1999', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (6, 'I1001', '04-NOV-2000', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (7, 'L2001', '13-MAY-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (4, 'L2001', '15-FEB-2001', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'L2001', '17-MAR-1999', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (8, 'L2002', '17-MAR-1999', NULL);
INSERT INTO Orders (CustomerID, PlanID, OrderDate, CancelationDate)
Values (9, 'L2003', '11-JUN-2000', NULL);