s_inventory.sql

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

DROP TABLE S_INVENTORY;
/
CREATE TABLE S_INVENTORY(
 PRODUCT_ID             NUMBER(7) 	NOT NULL,
 WAREHOUSE_ID		NUMBER(7)	NOT NULL,
 AMOUNT_IN_STOCK	NUMBER(9),
 REORDER_POINT		NUMBER(9),
 MAX_IN_STOCK		NUMBER(9),
 OUT_OF_STOCK_EXPLANATION	VARCHAR2(255),
 RESTOCK_DATE		DATE
  );
/
INSERT INTO S_INVENTORY VALUES (10011,101,650,625,1100,'',NULL);
INSERT INTO S_INVENTORY VALUES (10012,101,600,560,1000,'',NULL);
INSERT INTO S_INVENTORY VALUES (10012,10501,300,300,525,'',NULL);
INSERT INTO S_INVENTORY VALUES (10013,101,400,400,700,'',NULL);
INSERT INTO S_INVENTORY VALUES (10013,10501,314,300,525,'',NULL);
INSERT INTO S_INVENTORY VALUES (10021,101,500,425,740,'',NULL);
INSERT INTO S_INVENTORY VALUES (10022,101,300,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (10022,10501,502,300,525,'',NULL);
INSERT INTO S_INVENTORY VALUES (10023,101,400,300,525,'',NULL);
INSERT INTO S_INVENTORY VALUES (10023,10501,500,300,525,'',NULL);
INSERT INTO S_INVENTORY VALUES (20106,101,993,625,1000,'',NULL);
INSERT INTO S_INVENTORY VALUES (20106,201,220,150,260,'',NULL);
INSERT INTO S_INVENTORY VALUES (20106,10501,150,100,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (20108,101,700,700,1225,'',NULL);
INSERT INTO S_INVENTORY VALUES (20108,201,166,150,260,'',NULL);
INSERT INTO S_INVENTORY VALUES (20108,10501,222,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (20201,101,802,800,1400,'',NULL);
INSERT INTO S_INVENTORY VALUES (20201,201,320,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (20201,10501,275,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (20510,101,1389,850,1400,'',NULL);
INSERT INTO S_INVENTORY VALUES (20510,201,175,100,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (20510,301,69,40,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (20510,401,88,50,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (20510,10501,57,50,87,'',NULL);
INSERT INTO S_INVENTORY VALUES (20512,101,850,850,1450,'',NULL);
INSERT INTO S_INVENTORY VALUES (20512,201,162,100,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (20512,301,28,20,50,'',NULL);
INSERT INTO S_INVENTORY VALUES (20512,401,75,75,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (20512,10501,62,50,87,'',NULL);
INSERT INTO S_INVENTORY VALUES (30321,101,2000,1500,2500,'',NULL);
INSERT INTO S_INVENTORY VALUES (30321,201,96,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30321,301,85,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30321,401,102,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30321,10501,194,150,275,'',NULL);
INSERT INTO S_INVENTORY VALUES (30326,101,2100,2000,3500,'',NULL);
INSERT INTO S_INVENTORY VALUES (30326,201,147,120,210,'',NULL);
INSERT INTO S_INVENTORY VALUES (30326,401,113,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30326,10501,277,250,440,'',NULL);
INSERT INTO S_INVENTORY VALUES (30421,101,1822,1800,3150,'',NULL);
INSERT INTO S_INVENTORY VALUES (30421,201,102,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30421,301,102,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30421,401,85,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30421,10501,190,150,275,'',NULL);
INSERT INTO S_INVENTORY VALUES (30426,101,2250,2000,3500,'',NULL);
INSERT INTO S_INVENTORY VALUES (30426,201,200,120,210,'',NULL);
INSERT INTO S_INVENTORY VALUES (30426,401,135,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (30426,10501,423,250,450,'',NULL);
INSERT INTO S_INVENTORY VALUES (30433,101,650,600,1050,'',NULL);
INSERT INTO S_INVENTORY VALUES (30433,201,130,130,230,'',NULL);
INSERT INTO S_INVENTORY VALUES (30433,301,35,20,35,'',NULL);
INSERT INTO S_INVENTORY VALUES (30433,401,0,100,175,'A defective shipment was sent.','07-SEP-92');
INSERT INTO S_INVENTORY VALUES (30433,10501,273,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (32779,101,2120,1250,2200,'',NULL);
INSERT INTO S_INVENTORY VALUES (32779,201,180,150,260,'',NULL);
INSERT INTO S_INVENTORY VALUES (32779,301,102,95,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (32779,401,135,100,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (32779,10501,280,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (32861,101,505,500,875,'',NULL);
INSERT INTO S_INVENTORY VALUES (32861,201,132,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (32861,301,57,50,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (32861,401,250,150,250,'',NULL);
INSERT INTO S_INVENTORY VALUES (32861,10501,288,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (40421,101,578,350,600,'',NULL);
INSERT INTO S_INVENTORY VALUES (40421,301,70,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (40421,401,47,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (40421,10501,97,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (40422,101,0,350,600,'Phenomenal sales...','08-FEB-93');
INSERT INTO S_INVENTORY VALUES (40422,301,65,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (40422,401,50,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (40422,10501,90,80,140,'',NULL);
INSERT INTO S_INVENTORY VALUES (41010,101,250,250,437,'',NULL);
INSERT INTO S_INVENTORY VALUES (41010,301,59,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (41010,401,80,70,220,'',NULL);
INSERT INTO S_INVENTORY VALUES (41010,10501,151,140,245,'',NULL);
INSERT INTO S_INVENTORY VALUES (41020,101,471,450,750,'',NULL);
INSERT INTO S_INVENTORY VALUES (41020,301,61,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (41020,401,91,70,220,'',NULL);
INSERT INTO S_INVENTORY VALUES (41020,10501,224,140,245,'',NULL);
INSERT INTO S_INVENTORY VALUES (41050,101,501,450,750,'',NULL);
INSERT INTO S_INVENTORY VALUES (41050,301,49,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (41050,401,169,70,220,'',NULL);
INSERT INTO S_INVENTORY VALUES (41050,10501,157,140,245,'',NULL);
INSERT INTO S_INVENTORY VALUES (41080,101,400,400,700,'',NULL);
INSERT INTO S_INVENTORY VALUES (41080,301,50,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (41080,401,100,70,220,'',NULL);
INSERT INTO S_INVENTORY VALUES (41080,10501,159,140,245,'',NULL);
INSERT INTO S_INVENTORY VALUES (41100,101,350,350,600,'',NULL);
INSERT INTO S_INVENTORY VALUES (41100,301,42,40,70,'',NULL);
INSERT INTO S_INVENTORY VALUES (41100,401,75,70,220,'',NULL);
INSERT INTO S_INVENTORY VALUES (41100,10501,141,140,245,'',NULL);
INSERT INTO S_INVENTORY VALUES (50169,101,2530,1500,2600,'',NULL);
INSERT INTO S_INVENTORY VALUES (50169,201,225,220,385,'',NULL);
INSERT INTO S_INVENTORY VALUES (50169,401,240,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (50273,101,233,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (50273,201,75,60,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (50273,401,224,150,280,'',NULL);
INSERT INTO S_INVENTORY VALUES (50417,101,518,500,875,'',NULL);
INSERT INTO S_INVENTORY VALUES (50417,201,82,60,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (50417,401,130,120,210,'',NULL);
INSERT INTO S_INVENTORY VALUES (50418,101,244,100,275,'',NULL);
INSERT INTO S_INVENTORY VALUES (50418,201,98,60,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (50418,401,156,100,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (50419,101,230,120,310,'',NULL);
INSERT INTO S_INVENTORY VALUES (50419,201,77,60,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (50419,401,151,150,280,'',NULL);
INSERT INTO S_INVENTORY VALUES (50530,101,669,400,700,'',NULL);
INSERT INTO S_INVENTORY VALUES (50530,201,62,60,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (50530,401,119,100,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (50532,101,0,100,175,'Wait for Spring.','12-APR-93');
INSERT INTO S_INVENTORY VALUES (50532,201,67,60,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (53532,401,233,200,350,'',NULL);
INSERT INTO S_INVENTORY VALUES (50536,101,173,100,175,'',NULL);
INSERT INTO S_INVENTORY VALUES (50536,201,97,60,100,'',NULL);
INSERT INTO S_INVENTORY VALUES (50536,401,138,100,175,'',NULL);