s_product.sql

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

DROP TABLE S_PRODUCT;
/
CREATE TABLE S_PRODUCT(
 ID            	NUMBER(7) 	NOT NULL,
 NAME		VARCHAR2(50)	NOT NULL,
 SHORT_DESC	VARCHAR2(255),
 LONGTEXT_ID	NUMBER(7),
 IMAGE_ID	NUMBER(7),
 SUGGESTED_WHLSL_PRICE	NUMBER(11,2),
 WHLSL_UNITS		VARCHAR2(25)
   );
/
INSERT INTO S_PRODUCT VALUES (10011,'Bunny Boot','Beginner''s ski boot',518,1001,150,NULL);
INSERT INTO S_PRODUCT VALUES (10012,'Ace Ski Boot','Intermediate ski boot',519,1002,200,NULL);
INSERT INTO S_PRODUCT VALUES (10013,'Pro Ski Boot','Advanced ski boot',520,1003,410,NULL);
INSERT INTO S_PRODUCT VALUES (10021,'Bunny Boot','Beginner''s ski pole',528,1011,16.25,NULL);
INSERT INTO S_PRODUCT VALUES (10022,'Ace Ski Boot','Intermediate ski pole',529,1012,21.95,NULL);
INSERT INTO S_PRODUCT VALUES (10023,'Pro Ski Boot','Advanced ski pole',530,1013,40.95,NULL);
INSERT INTO S_PRODUCT VALUES (20106,'Junior Soccer Ball','Junior Soccer Ball',613,NULL,11,NULL);
INSERT INTO S_PRODUCT VALUES (20108,'World Cup Soccer Ball','World Cup Soccer Ball',615,NULL,28,NULL);
INSERT INTO S_PRODUCT VALUES (20201,'World Cup Net','World Cup Net',708,NULL,123,NULL);
INSERT INTO S_PRODUCT VALUES (20510,'Black Hawk Knee Pads','Knee pads,pair',1017,NULL,9,NULL);
INSERT INTO S_PRODUCT VALUES (20512,'Black Hawk Elbow Pads','Elbow pads,pair',1019,NULL,8,NULL);
INSERT INTO S_PRODUCT VALUES (30321,'Grand Prix Bicycle','Road bicycle tires',828,1291,1669,NULL);
INSERT INTO S_PRODUCT VALUES (30326,'Himalaya Tires','Mountain bicycle ',833,1296,582,NULL);
INSERT INTO S_PRODUCT VALUES (30421,'Grand Prix Bicycle Tires','Road bicycle tires',927,NULL,16,NULL);
INSERT INTO S_PRODUCT VALUES (30426,'Himalaya Tires','Mountain bicycle tires',933,NULL,18.25,NULL);
INSERT INTO S_PRODUCT VALUES (30433,'New Air Pump','Tire pump',940,NULL,20,NULL);
INSERT INTO S_PRODUCT VALUES (32779,'Slaker Water Bottle','Water bottle',1286,NULL,7,NULL);
INSERT INTO S_PRODUCT VALUES (32861,'Saft-T Helmet','Bicycle helmet',1368,1829,60,NULL);
INSERT INTO S_PRODUCT VALUES (40421,'Alexeyer Pro Lifting Bar','Straight bar',928,1381,65,NULL);
INSERT INTO S_PRODUCT VALUES (40422,'Pro Curling Bar','Curling bar',929,1382,50,NULL);
INSERT INTO S_PRODUCT VALUES (41010,'Prostar 10 Pound Weight','Ten pound weight',517,NULL,8,NULL);
INSERT INTO S_PRODUCT VALUES (41020,'Prostar 20 Pound Weight','Twenty pound weight',527,NULL,12,NULL);
INSERT INTO S_PRODUCT VALUES (41050,'Prostar 50 Pound Weight','Fifty pound weight',557,NULL,25,NULL);
INSERT INTO S_PRODUCT VALUES (41080,'Prostar 80 Pound Weight','Eighty pound weight',587,NULL,35,NULL);
INSERT INTO S_PRODUCT VALUES (50169,'Major League Baseball','Baseball',676,1119,4.29,NULL);
INSERT INTO S_PRODUCT VALUES (50273,'Chapman Helmet','Batting helmet',780,1223,22.89,NULL);
INSERT INTO S_PRODUCT VALUES (50417,'Griffey Glove','Outfielder''s glove',924,1367,80,NULL);
INSERT INTO S_PRODUCT VALUES (50418,'Alomar Glove','Infielder''s glove',925,1368,75,NULL);
INSERT INTO S_PRODUCT VALUES (50419,'Steinbach Glove','Catcher''s glove',926,1369,80,NULL);
INSERT INTO S_PRODUCT VALUES (50530,'Cabrera Bat','Thirty inch bat',1037,1480,45,NULL);
INSERT INTO S_PRODUCT VALUES (50532,'Puckett Bat','Thirty-two inch bat',1039,1482,47,NULL);
INSERT INTO S_PRODUCT VALUES (50536,'Winfield Bat','Thirty-six inch bat',1043,1486,50,NULL);