s_customer.sql

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

DROP TABLE S_CUSTOMER;
/
CREATE TABLE S_CUSTOMER (
 ID             NUMBER(7) 	NOT NULL,
 NAME		VARCHAR2(50)	NOT NULL,
 PHONE		VARCHAR2(25),
 ADDRESS	VARCHAR2(400),
 CITY		VARCHAR2(30),
 STATE		VARCHAR2(20),
 COUNTRY	VARCHAR2(30),
 ZIP_CODE	VARCHAR2(75),
 CREDIT_RATING	VARCHAR2(9),
 SALES_REP_ID 	VARCHAR2(7),
 REGION_ID	NUMBER(7),
 COMMENTS	VARCHAR2(255)	
 );
/

INSERT INTO S_CUSTOMER VALUES (201,'Unisports','55-2066101','72 Via Bahia','Sao Paolo','CA','Brazil','','EXCELLENT','12',2,'Customer usually orders large amounts and has a high order total.');
INSERT INTO S_CUSTOMER VALUES (202,'Simms Atheletics','81-20101','6741 Takashi Blvd.','Osaka','CA','Japan','','POOR','14',4,'Customer should always pay by cash until his credit rating improves.');
INSERT INTO S_CUSTOMER VALUES (203,'Delhi Sports','91-10351','11368 Chanakya','New Delhi','CA','India','','GOOD','14',4,'Customer specializes in baseball equipment and is the largest retailer in India.');
INSERT INTO S_CUSTOMER VALUES (204,'Womansport','1-206-104-0103','281 King Street','Seattle','CA','USA','98101','EXCELLENT','11',1,'');
INSERT INTO S_CUSTOMER VALUES (205,'Kam''s Sporting Goods','852-3692888','15 Henessey Road','Hong Kong','CA','','','EXCELLENT','15',4,'');
INSERT INTO S_CUSTOMER VALUES (206,'Sportique','33-2257201','172 Rue de Rivoli','Cannes','CA','France','','EXCELLENT','15',5,'Customer specializes in Soccer. Likes to order accessories in bright colors');
INSERT INTO S_CUSTOMER VALUES (207,'Sweet Rock Sports','234-6036201','6 Saint Antoine','Lagos','CA','Nigeria','','GOOD','',3,'');
INSERT INTO S_CUSTOMER VALUES (208,'Muench Sports','49-527454','435 Gruenestrasse','Stuttgart','CA','Germany','','GOOD','15',5,'Customer usually pays small orders by cash and large orders on credit.');
INSERT INTO S_CUSTOMER VALUES (209,'Beisbol Sil','809-352689','792 Playa Del Mar','San Pedro de Macon''s','CA','Dominican Republic','','EXCELLENT','11',1,'');
INSERT INTO S_CUSTOMER VALUES (210,'Futbol Sonora','52-404562','3 Via Saguaro','Nogales','CA','Mexico','','EXCELLENT','12',2,'Customer is difficult to reach by phone. Try mail');
INSERT INTO S_CUSTOMER VALUES (211,'Kuhn''s Sports','42-111292','7 Modrany','Prague','CA','Czechoslovakia','','EXCELLENT','15',5,'');
INSERT INTO S_CUSTOMER VALUES (212,'Hamada Sport','20-1209211','57A Corniche','Alexandria','CA','Egypt','','EXCELLENT','13',3,'Customer orders sea and water equipment.');
INSERT INTO S_CUSTOMER VALUES (213,'Big John''s Sports Emporium','1-415-555-6281','4783 18th Street','San Francisco','CA','USA','94117','EXCELLENT','11',1,'Customer has a dependable credit record.');
INSERT INTO S_CUSTOMER VALUES (214,'Ojibway Retail','1-716-555-7171','415 Main Street','Buffalo','CA','USA','14202','POOR','11',1,'');
INSERT INTO S_CUSTOMER VALUES (215,'Sports Russia','7-3892456','6000 Yekatamina','Saint Petersburg','CA','Russia','','POOR','15',5,'This customer is very friendly,but has difficulty paying bills. Insist upon cash.');