s_ord.sql

SQL 语言二次开发实际经典开发实例希望对初学者有帮助

DROP TABLE S_ORD;
/
CREATE TABLE S_ORD(
 ID             	NUMBER(7) 	NOT NULL,
 CUSTOMER_ID		NUMBER(7)	NOT NULL,
 DATE_ORDERED		DATE,
 DATE_SHIPPED		DATE,
 SALES_REP_ID		NUMBER(7),
 TOTAL			NUMBER(11,2),
 PAYMENT_TYPE		VARCHAR2(6),
 ORDER_FILLED		VARCHAR2(1)
   );
/
INSERT INTO S_ORD VALUES (100,204,'31-AUG-92','10-SEP-92',11,601100,'CREDIT','Y');
INSERT INTO S_ORD VALUES (101,205,'31-AUG-92','15-SEP-92',14,8056.6,'CREDIT',NULL);
INSERT INTO S_ORD VALUES (102,206,'01-SEP-92','08-SEP-92',15,8335,'CREDIT','N');
INSERT INTO S_ORD VALUES (103,208,'02-SEP-92','22-SEP-92',15,377,'CASH','Y');
INSERT INTO S_ORD VALUES (104,208,'03-SEP-92','23-SEP-92',15,32430,'CREDIT','N');
INSERT INTO S_ORD VALUES (105,209,'04-SEP-92','18-SEP-92',11,2722.24,'CREDIT','Y');
INSERT INTO S_ORD VALUES (106,210,'07-SEP-92','15-SEP-92',12,15634,'CREDIT','N');
INSERT INTO S_ORD VALUES (107,211,'07-SEP-92','21-SEP-92',15,142171,'CREDIT','Y');
INSERT INTO S_ORD VALUES (108,212,'07-SEP-92','10-SEP-92',13,149570,'CREDIT','N');
INSERT INTO S_ORD VALUES (109,213,'08-SEP-92','28-SEP-92',11,1020935,'CREDIT','Y');
INSERT INTO S_ORD VALUES (110,214,'09-SEP-92','21-SEP-92',11,1539.13,'CASH','N');
INSERT INTO S_ORD VALUES (111,204,'09-SEP-92','21-SEP-92',11,2770,'CASH','Y');
INSERT INTO S_ORD VALUES (97,201,'28-AUG-92','17-SEP-92',12,84000,'CREDIT','N');
INSERT INTO S_ORD VALUES (98,202,'31-AUG-92','10-SEP-92',14,595,'CASH','Y');
INSERT INTO S_ORD VALUES (99,203,'31-AUG-92','18-SEP-92',14,7707,'CREDIT','N');
INSERT INTO S_ORD VALUES (112,210,'31-AUG-92','10-SEP-92',12,550,'CREDIT','Y');