s_item.sql

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

DROP TABLE S_ITEM;
/
CREATE TABLE S_ITEM(
 ORD_ID             	NUMBER(7) 	NOT NULL,
 ITEM_ID		NUMBER(7)	NOT NULL,
 PRODUCT_ID		NUMBER(7)	NOT NULL,
 PRICE			NUMBER(11,2),
 QUANTITY		NUMBER(9),
 QUANTITY_SHIPPED	NUMBER(9)
   );
/
INSERT INTO S_ITEM VALUES (97,1,20106,9,1000,1000);
INSERT INTO S_ITEM VALUES (97,2,30321,1500,50,50);
INSERT INTO S_ITEM VALUES (98,1,40421,85,7,7);
INSERT INTO S_ITEM VALUES (99,1,20510,9,18,18);
INSERT INTO S_ITEM VALUES (99,2,20512,8,25,25);
INSERT INTO S_ITEM VALUES (99,3,50417,80,53,53);
INSERT INTO S_ITEM VALUES (99,4,50530,45,69,69);
INSERT INTO S_ITEM VALUES (100,1,10011,135,500,500);
INSERT INTO S_ITEM VALUES (100,2,10013,380,400,400);
INSERT INTO S_ITEM VALUES (100,3,10021,14,500,500);
INSERT INTO S_ITEM VALUES (100,4,10023,36,400,400);
INSERT INTO S_ITEM VALUES (100,5,30326,582,600,600);
INSERT INTO S_ITEM VALUES (100,6,30433,20,450,450);
INSERT INTO S_ITEM VALUES (100,7,41010,8,250,250);
INSERT INTO S_ITEM VALUES (101,1,30421,16,15,15);
INSERT INTO S_ITEM VALUES (101,2,40422,50,30,30);
INSERT INTO S_ITEM VALUES (101,3,41010,8,20,20);
INSERT INTO S_ITEM VALUES (101,4,41100,45,35,35);
INSERT INTO S_ITEM VALUES (101,5,50169,4.29,40,40);
INSERT INTO S_ITEM VALUES (101,6,50417,80,27,27);
INSERT INTO S_ITEM VALUES (101,7,50530,45,50,50);
INSERT INTO S_ITEM VALUES (102,1,20108,28,100,100);
INSERT INTO S_ITEM VALUES (102,2,20201,123,45,45);
INSERT INTO S_ITEM VALUES (103,1,30433,20,15,15);
INSERT INTO S_ITEM VALUES (103,2,32779,7,11,11);
INSERT INTO S_ITEM VALUES (104,1,20510,9,7,7);
INSERT INTO S_ITEM VALUES (104,2,20512,8,12,12);
INSERT INTO S_ITEM VALUES (104,3,30321,1669,19,19);
INSERT INTO S_ITEM VALUES (104,4,30421,16,35,35);
INSERT INTO S_ITEM VALUES (105,1,50273,22.89,16,16);
INSERT INTO S_ITEM VALUES (105,2,50419,80,13,13);
INSERT INTO S_ITEM VALUES (105,3,50532,47,28,28);
INSERT INTO S_ITEM VALUES (106,1,20108,28,46,46);
INSERT INTO S_ITEM VALUES (106,2,20201,123,21,21);
INSERT INTO S_ITEM VALUES (106,3,50169,4.29,125,125);
INSERT INTO S_ITEM VALUES (106,4,50273,22.89,75,75);
INSERT INTO S_ITEM VALUES (106,5,50418,75,98,98);
INSERT INTO S_ITEM VALUES (106,6,50419,80,27,27);
INSERT INTO S_ITEM VALUES (107,1,20106,11,50,50);
INSERT INTO S_ITEM VALUES (107,2,20108,28,22,22);
INSERT INTO S_ITEM VALUES (107,3,20201,115,130,130);
INSERT INTO S_ITEM VALUES (107,4,30321,1669,75,75);
INSERT INTO S_ITEM VALUES (107,5,30421,16,55,55);
INSERT INTO S_ITEM VALUES (108,1,20510,9,9,9);
INSERT INTO S_ITEM VALUES (108,2,20512,8,18,18);
INSERT INTO S_ITEM VALUES (108,3,30321,1669,85,85);
INSERT INTO S_ITEM VALUES (108,4,32779,7,60,60);
INSERT INTO S_ITEM VALUES (108,5,32861,60,57,57);
INSERT INTO S_ITEM VALUES (108,6,41080,35,50,50);
INSERT INTO S_ITEM VALUES (108,7,41100,45,42,42);
INSERT INTO S_ITEM VALUES (109,1,10011,140,150,150);
INSERT INTO S_ITEM VALUES (109,2,10012,175,600,600);
INSERT INTO S_ITEM VALUES (109,3,10022,21.95,300,300);
INSERT INTO S_ITEM VALUES (109,4,30326,582,1500,1500);
INSERT INTO S_ITEM VALUES (109,5,30426,18.25,500,500);
INSERT INTO S_ITEM VALUES (109,6,32861,60,50,50);
INSERT INTO S_ITEM VALUES (109,7,50418,75,43,43);
INSERT INTO S_ITEM VALUES (110,1,50273,22.89,17,17);
INSERT INTO S_ITEM VALUES (110,2,50536,50,23,23);
INSERT INTO S_ITEM VALUES (111,1,40421,65,27,27);
INSERT INTO S_ITEM VALUES (111,2,41080,35,29,29);
INSERT INTO S_ITEM VALUES (112,1,20106,11,50,50);