API tools faq
paste
Advertisement
WSTI

rndb

WSTI
Nov 5th, 2014
855
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Openoffice BASIC 101.03 KB | None | 0 0
raw download clone embed print report
  1. --------------------------------------------------------
  2. --  File created - środa-listopad-05-2014  
  3. --------------------------------------------------------
  4. --------------------------------------------------------
  5. --  DDL for Table S_CUSTOMER
  6. --------------------------------------------------------
  7.  
  8.   CREATE TABLE "2955"."S_CUSTOMER"
  9.    (    "ID" NUMBER(7,0),
  10.     "NAME" VARCHAR2(50 BYTE),
  11.     "PHONE" VARCHAR2(25 BYTE),
  12.     "ADDRESS" VARCHAR2(400 BYTE),
  13.     "CITY" VARCHAR2(30 BYTE),
  14.     "STATE" VARCHAR2(20 BYTE),
  15.     "COUNTRY" VARCHAR2(30 BYTE),
  16.     "ZIP_CODE" VARCHAR2(75 BYTE),
  17.     "CREDIT_RATING" VARCHAR2(9 BYTE),
  18.     "SALES_REP_ID" NUMBER(7,0),
  19.     "REGION_ID" NUMBER(7,0),
  20.     "COMMENTS" VARCHAR2(255 BYTE)
  21.    ) SEGMENT CREATION IMMEDIATE
  22.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  23.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  24.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  25.   TABLESPACE "AB" ;
  26. --------------------------------------------------------
  27. --  DDL for Table S_DEPT
  28. --------------------------------------------------------
  29.  
  30.   CREATE TABLE "2955"."S_DEPT"
  31.    (    "ID" NUMBER(7,0),
  32.     "NAME" VARCHAR2(25 BYTE),
  33.     "REGION_ID" NUMBER(7,0)
  34.    ) SEGMENT CREATION IMMEDIATE
  35.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  36.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  37.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  38.   TABLESPACE "AB" ;
  39. --------------------------------------------------------
  40. --  DDL for Table S_EMP
  41. --------------------------------------------------------
  42.  
  43.   CREATE TABLE "2955"."S_EMP"
  44.    (    "ID" NUMBER(7,0),
  45.     "LAST_NAME" VARCHAR2(25 BYTE),
  46.     "FIRST_NAME" VARCHAR2(25 BYTE),
  47.     "USERID" VARCHAR2(8 BYTE),
  48.     "START_DATE" DATE,
  49.     "COMMENTS" VARCHAR2(255 BYTE),
  50.     "MANAGER_ID" NUMBER(7,0),
  51.     "TITLE" VARCHAR2(25 BYTE),
  52.     "DEPT_ID" NUMBER(7,0),
  53.     "SALARY" NUMBER(11,2),
  54.     "COMMISSION_PCT" NUMBER(4,2)
  55.    ) SEGMENT CREATION IMMEDIATE
  56.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  57.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  58.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  59.   TABLESPACE "AB" ;
  60. --------------------------------------------------------
  61. --  DDL for Table S_IMAGE
  62. --------------------------------------------------------
  63.  
  64.   CREATE TABLE "2955"."S_IMAGE"
  65.    (    "ID" NUMBER(7,0),
  66.     "FORMAT" VARCHAR2(25 BYTE),
  67.     "USE_FILENAME" VARCHAR2(1 BYTE),
  68.     "FILENAME" VARCHAR2(255 BYTE),
  69.     "IMAGE" LONG RAW
  70.    ) SEGMENT CREATION IMMEDIATE
  71.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  72.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  73.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  74.   TABLESPACE "AB" ;
  75. --------------------------------------------------------
  76. --  DDL for Table S_INVENTORY
  77. --------------------------------------------------------
  78.  
  79.   CREATE TABLE "2955"."S_INVENTORY"
  80.    (    "PRODUCT_ID" NUMBER(7,0),
  81.     "WAREHOUSE_ID" NUMBER(7,0),
  82.     "AMOUNT_IN_STOCK" NUMBER(9,0),
  83.     "REORDER_POINT" NUMBER(9,0),
  84.     "MAX_IN_STOCK" NUMBER(9,0),
  85.     "OUT_OF_STOCK_EXPLANATION" VARCHAR2(255 BYTE),
  86.     "RESTOCK_DATE" DATE
  87.    ) SEGMENT CREATION IMMEDIATE
  88.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  89.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  90.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  91.   TABLESPACE "AB" ;
  92. --------------------------------------------------------
  93. --  DDL for Table S_ITEM
  94. --------------------------------------------------------
  95.  
  96.   CREATE TABLE "2955"."S_ITEM"
  97.    (    "ORD_ID" NUMBER(7,0),
  98.     "ITEM_ID" NUMBER(7,0),
  99.     "PRODUCT_ID" NUMBER(7,0),
  100.     "PRICE" NUMBER(11,2),
  101.     "QUANTITY" NUMBER(9,0),
  102.     "QUANTITY_SHIPPED" NUMBER(9,0)
  103.    ) SEGMENT CREATION IMMEDIATE
  104.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  105.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  106.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  107.   TABLESPACE "AB" ;
  108. --------------------------------------------------------
  109. --  DDL for Table S_LARGE_EMP
  110. --------------------------------------------------------
  111.  
  112.   CREATE TABLE "2955"."S_LARGE_EMP"
  113.    (    "ID" NUMBER(7,0),
  114.     "LAST_NAME" VARCHAR2(25 BYTE),
  115.     "FIRST_NAME" VARCHAR2(25 BYTE),
  116.     "USERID" VARCHAR2(8 BYTE),
  117.     "START_DATE" DATE,
  118.     "COMMENTS" VARCHAR2(255 BYTE),
  119.     "MANAGER_ID" NUMBER(7,0),
  120.     "TITLE" VARCHAR2(25 BYTE),
  121.     "DEPT_ID" NUMBER(7,0),
  122.     "SALARY" NUMBER(11,2),
  123.     "COMMISSION_PCT" NUMBER(4,2),
  124.     "PHONE" VARCHAR2(25 BYTE),
  125.     "ADDRESS" VARCHAR2(255 BYTE),
  126.     "CITY" VARCHAR2(30 BYTE),
  127.     "STATE" VARCHAR2(20 BYTE),
  128.     "COUNTRY" VARCHAR2(30 BYTE),
  129.     "ZIP_CODE" VARCHAR2(75 BYTE),
  130.     "BIRTH_DATE" DATE,
  131.     "ROOM_PHONE" VARCHAR2(10 BYTE),
  132.     "ROOM_NO" NUMBER(4,0)
  133.    ) SEGMENT CREATION IMMEDIATE
  134.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  135.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  136.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  137.   TABLESPACE "AB" ;
  138. --------------------------------------------------------
  139. --  DDL for Table S_LONGTEXT
  140. --------------------------------------------------------
  141.  
  142.   CREATE TABLE "2955"."S_LONGTEXT"
  143.    (    "ID" NUMBER(7,0),
  144.     "USE_FILENAME" VARCHAR2(1 BYTE),
  145.     "FILENAME" VARCHAR2(255 BYTE),
  146.     "TEXT" VARCHAR2(2000 BYTE)
  147.    ) SEGMENT CREATION IMMEDIATE
  148.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  149.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  150.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  151.   TABLESPACE "AB" ;
  152. --------------------------------------------------------
  153. --  DDL for Table S_ORD
  154. --------------------------------------------------------
  155.  
  156.   CREATE TABLE "2955"."S_ORD"
  157.    (    "ID" NUMBER(7,0),
  158.     "CUSTOMER_ID" NUMBER(7,0),
  159.     "DATE_ORDERED" DATE,
  160.     "DATE_SHIPPED" DATE,
  161.     "SALES_REP_ID" NUMBER(7,0),
  162.     "TOTAL" NUMBER(11,2),
  163.     "PAYMENT_TYPE" VARCHAR2(6 BYTE),
  164.     "ORDER_FILLED" VARCHAR2(1 BYTE)
  165.    ) SEGMENT CREATION IMMEDIATE
  166.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  167.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  168.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  169.   TABLESPACE "AB" ;
  170. --------------------------------------------------------
  171. --  DDL for Table S_PRODUCT
  172. --------------------------------------------------------
  173.  
  174.   CREATE TABLE "2955"."S_PRODUCT"
  175.    (    "ID" NUMBER(7,0),
  176.     "NAME" VARCHAR2(50 BYTE),
  177.     "SHORT_DESC" VARCHAR2(255 BYTE),
  178.     "LONGTEXT_ID" NUMBER(7,0),
  179.     "IMAGE_ID" NUMBER(7,0),
  180.     "SUGGESTED_WHLSL_PRICE" NUMBER(11,2),
  181.     "WHLSL_UNITS" VARCHAR2(25 BYTE)
  182.    ) SEGMENT CREATION IMMEDIATE
  183.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  184.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  185.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  186.   TABLESPACE "AB" ;
  187. --------------------------------------------------------
  188. --  DDL for Table S_REGION
  189. --------------------------------------------------------
  190.  
  191.   CREATE TABLE "2955"."S_REGION"
  192.    (    "ID" NUMBER(7,0),
  193.     "NAME" VARCHAR2(50 BYTE)
  194.    ) SEGMENT CREATION IMMEDIATE
  195.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  196.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  197.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  198.   TABLESPACE "AB" ;
  199. --------------------------------------------------------
  200. --  DDL for Table S_TITLE
  201. --------------------------------------------------------
  202.  
  203.   CREATE TABLE "2955"."S_TITLE"
  204.    (    "TITLE" VARCHAR2(25 BYTE)
  205.    ) SEGMENT CREATION IMMEDIATE
  206.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  207.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  208.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  209.   TABLESPACE "AB" ;
  210. --------------------------------------------------------
  211. --  DDL for Table S_WAREHOUSE
  212. --------------------------------------------------------
  213.  
  214.   CREATE TABLE "2955"."S_WAREHOUSE"
  215.    (    "ID" NUMBER(7,0),
  216.     "REGION_ID" NUMBER(7,0),
  217.     "ADDRESS" LONG,
  218.     "CITY" VARCHAR2(30 BYTE),
  219.     "STATE" VARCHAR2(20 BYTE),
  220.     "COUNTRY" VARCHAR2(30 BYTE),
  221.     "ZIP_CODE" VARCHAR2(75 BYTE),
  222.     "PHONE" VARCHAR2(25 BYTE),
  223.     "MANAGER_ID" NUMBER(7,0)
  224.    ) SEGMENT CREATION IMMEDIATE
  225.   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  226.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  227.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  228.   TABLESPACE "AB" ;
  229. REM INSERTING into "2955".S_CUSTOMER
  230. SET DEFINE OFF;
  231. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('201','Unisports','55-2066101','72 Via Bahia','Sao Paolo',null,'Brazil',null,'EXCELLENT','12','2','Customer usually orders large amounts and has a high order total.  This is okay as long as the credit rating remains excellent.');
  232. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('202','Simms Atheletics','81-20101','6741 Takashi Blvd.','Osaka',null,'Japan',null,'POOR','14','4','Customer should always pay by cash until his credit rating improves.');
  233. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('203','Delhi Sports','91-10351','11368 Chanakya','New Delhi',null,'India',null,'GOOD','14','4','Customer specializes in baseball equipment and is the largest retailer in India.');
  234. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('204','Womansport','1-206-104-0103','281 King Street','Seattle','Washington','USA','98101','EXCELLENT','11','1',null);
  235. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('205','Kam''s Sporting Goods','852-3692888','15 Henessey Road','Hong Kong',null,null,null,'EXCELLENT','15','4',null);
  236. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('206','Sportique','33-2257201','172 Rue de Rivoli','Cannes',null,'France',null,'EXCELLENT','15','5','Customer specializes in Soccer.  Likes to order accessories in bright colors.');
  237. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('207','Sweet Rock Sports','234-6036201','6 Saint Antoine','Lagos',null,'Nigeria',null,'GOOD',null,'3',null);
  238. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('208','Muench Sports','49-527454','435 Gruenestrasse','Stuttgart',null,'Germany',null,'GOOD','15','5','Customer usually pays small orders by cash and large orders on credit.');
  239. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('209','Beisbol Si!','809-352689','792 Playa Del Mar','San Pedro de Macon''s',null,'Dominican Republic',null,'EXCELLENT','11','1',null);
  240. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('210','Futbol Sonora','52-404562','3 Via Saguaro','Nogales',null,'Mexico',null,'EXCELLENT','12','2','Customer is difficult to reach by phone.  Try mail.');
  241. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('211','Kuhn''s Sports','42-111292','7 Modrany','Prague',null,'Czechoslovakia',null,'EXCELLENT','15','5',null);
  242. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('212','Hamada Sport','20-1209211','57A Corniche','Alexandria',null,'Egypt',null,'EXCELLENT','13','3','Customer orders sea and water equipment.');
  243. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) 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.');
  244. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('214','Ojibway Retail','1-716-555-7171','415 Main Street','Buffalo','NY','USA','14202','POOR','11','1',null);
  245. Insert into "2955".S_CUSTOMER (ID,NAME,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,CREDIT_RATING,SALES_REP_ID,REGION_ID,COMMENTS) values ('215','Sporta Russia','7-3892456','6000 Yekatamina','Saint Petersburg',null,'Russia',null,'POOR','15','5','This customer is very friendly, but has difficulty paying bills.  Insist upon cash.');
  246. REM INSERTING into "2955".S_DEPT
  247. SET DEFINE OFF;
  248. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('50','Administration','1');
  249. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('10','Finance','1');
  250. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('41','Operations','1');
  251. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('42','Operations','2');
  252. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('43','Operations','3');
  253. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('44','Operations','4');
  254. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('45','Operations','5');
  255. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('31','Sales','1');
  256. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('32','Sales','2');
  257. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('33','Sales','3');
  258. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('34','Sales','4');
  259. Insert into "2955".S_DEPT (ID,NAME,REGION_ID) values ('35','Sales','5');
  260. REM INSERTING into "2955".S_EMP
  261. SET DEFINE OFF;
  262. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('1','Velasquez','Carmen','cvelasqu',to_date('90/03/03','RR/MM/DD'),null,null,'President','50','2500',null);
  263. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('2','Ngao','LaDoris','lngao',to_date('90/03/08','RR/MM/DD'),null,'1','VP, Operations','41','1450',null);
  264. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('3','Nagayama','Midori','mnagayam',to_date('91/06/17','RR/MM/DD'),null,'1','VP, Sales','31','1400',null);
  265. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('4','Quick-To-See','Mark','mquickto',to_date('90/04/07','RR/MM/DD'),null,'1','VP, Finance','10','1450',null);
  266. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('5','Ropeburn','Audry','aropebur',to_date('90/03/04','RR/MM/DD'),null,'1','VP, Administration','50','1550',null);
  267. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('6','Urguhart','Molly','murguhar',to_date('91/01/18','RR/MM/DD'),null,'2','Warehouse Manager','41','1200',null);
  268. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('7','Menchu','Roberta','rmenchu',to_date('90/05/14','RR/MM/DD'),null,'2','Warehouse Manager','42','1250',null);
  269. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('8','Biri','Ben','bbiri',to_date('90/04/07','RR/MM/DD'),null,'2','Warehouse Manager','43','1100',null);
  270. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('9','Catchpole','Antoinette','acatchpo',to_date('92/02/09','RR/MM/DD'),null,'2','Warehouse Manager','44','1300',null);
  271. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('10','Havel','Marta','mhavel',to_date('91/02/27','RR/MM/DD'),null,'2','Warehouse Manager','45','1307',null);
  272. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('11','Magee','Colin','cmagee',to_date('90/05/14','RR/MM/DD'),null,'3','Sales Representative','31','1400','10');
  273. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('12','Giljum','Henry','hgiljum',to_date('92/01/18','RR/MM/DD'),null,'3','Sales Representative','32','1490','12,5');
  274. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('13','Sedeghi','Yasmin','ysedeghi',to_date('91/02/18','RR/MM/DD'),null,'3','Sales Representative','33','1515','10');
  275. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('14','Nguyen','Mai','mnguyen',to_date('92/01/22','RR/MM/DD'),null,'3','Sales Representative','34','1525','15');
  276. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('15','Dumas','Andre','adumas',to_date('91/10/09','RR/MM/DD'),null,'3','Sales Representative','35','1450','17,5');
  277. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('16','Maduro','Elena','emaduro',to_date('92/02/07','RR/MM/DD'),null,'6','Stock Clerk','41','1400',null);
  278. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('17','Smith','George','gsmith',to_date('90/03/08','RR/MM/DD'),null,'6','Stock Clerk','41','940',null);
  279. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('18','Nozaki','Akira','anozaki',to_date('91/02/09','RR/MM/DD'),null,'7','Stock Clerk','42','1200',null);
  280. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('19','Patel','Vikram','vpatel',to_date('91/08/06','RR/MM/DD'),null,'7','Stock Clerk','42','795',null);
  281. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('20','Newman','Chad','cnewman',to_date('91/07/21','RR/MM/DD'),null,'8','Stock Clerk','43','750',null);
  282. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('21','Markarian','Alexander','amarkari',to_date('91/05/26','RR/MM/DD'),null,'8','Stock Clerk','43','850',null);
  283. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('22','Chang','Eddie','echang',to_date('90/11/30','RR/MM/DD'),null,'9','Stock Clerk','44','800',null);
  284. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('23','Patel','Radha','rpatel',to_date('90/10/17','RR/MM/DD'),null,'9','Stock Clerk','34','795',null);
  285. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('24','Dancs','Bela','bdancs',to_date('91/03/17','RR/MM/DD'),null,'10','Stock Clerk','45','860',null);
  286. Insert into "2955".S_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT) values ('25','Schwartz','Sylvie','sschwart',to_date('91/05/09','RR/MM/DD'),null,'10','Stock Clerk','45','1100',null);
  287. REM INSERTING into "2955".S_IMAGE
  288. SET DEFINE OFF;
  289. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1001','JTIFF','Y','bunboot.tif',null);
  290. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1002','JTIFF','Y','aceboot.tif',null);
  291. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1003','JTIFF','Y','proboot.tif',null);
  292. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1011','JTIFF','Y','bunpole.tif',null);
  293. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1012','JTIFF','Y','acepole.tif',null);
  294. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1013','JTIFF','Y','propole.tif',null);
  295. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1291','JTIFF','Y','gpbike.tif',null);
  296. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1296','JTIFF','Y','himbike.tif',null);
  297. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1829','JTIFF','Y','safthelm.tif',null);
  298. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1381','JTIFF','Y','probar.tif',null);
  299. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1382','JTIFF','Y','curlbar.tif',null);
  300. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1119','JTIFF','Y','baseball.tif',null);
  301. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1223','JTIFF','Y','chaphelm.tif',null);
  302. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1367','JTIFF','Y','grglove.tif',null);
  303. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1368','JTIFF','Y','alglove.tif',null);
  304. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1369','JTIFF','Y','stglove.tif',null);
  305. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1480','JTIFF','Y','cabbat.tif',null);
  306. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1482','JTIFF','Y','pucbat.tif',null);
  307. Insert into "2955".S_IMAGE (ID,FORMAT,USE_FILENAME,FILENAME,IMAGE) values ('1486','JTIFF','Y','winbat.tif',null);
  308. REM INSERTING into "2955".S_INVENTORY
  309. SET DEFINE OFF;
  310. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10011','101','650','625','1100',null,null);
  311. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10012','101','600','560','1000',null,null);
  312. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10013','101','400','400','700',null,null);
  313. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10021','101','500','425','740',null,null);
  314. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10022','101','300','200','350',null,null);
  315. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10023','101','400','300','525',null,null);
  316. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20106','101','993','625','1000',null,null);
  317. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20108','101','700','700','1225',null,null);
  318. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20201','101','802','800','1400',null,null);
  319. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20510','101','1389','850','1400',null,null);
  320. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20512','101','850','850','1450',null,null);
  321. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30321','101','2000','1500','2500',null,null);
  322. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30326','101','2100','2000','3500',null,null);
  323. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30421','101','1822','1800','3150',null,null);
  324. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30426','101','2250','2000','3500',null,null);
  325. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30433','101','650','600','1050',null,null);
  326. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32779','101','2120','1250','2200',null,null);
  327. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32861','101','505','500','875',null,null);
  328. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40421','101','578','350','600',null,null);
  329. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40422','101','0','350','600','Phenomenal sales...',to_date('93/02/08','RR/MM/DD'));
  330. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41010','101','250','250','437',null,null);
  331. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41020','101','471','450','750',null,null);
  332. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41050','101','501','450','750',null,null);
  333. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41080','101','400','400','700',null,null);
  334. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41100','101','350','350','600',null,null);
  335. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50169','101','2530','1500','2600',null,null);
  336. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50273','101','233','200','350',null,null);
  337. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50417','101','518','500','875',null,null);
  338. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50418','101','244','100','275',null,null);
  339. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50419','101','230','120','310',null,null);
  340. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50530','101','669','400','700',null,null);
  341. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50532','101','0','100','175','Wait for Spring.',to_date('93/04/12','RR/MM/DD'));
  342. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50536','101','173','100','175',null,null);
  343. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20106','201','220','150','260',null,null);
  344. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20108','201','166','150','260',null,null);
  345. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20201','201','320','200','350',null,null);
  346. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20510','201','175','100','175',null,null);
  347. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20512','201','162','100','175',null,null);
  348. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30321','201','96','80','140',null,null);
  349. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30326','201','147','120','210',null,null);
  350. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30421','201','102','80','140',null,null);
  351. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30426','201','200','120','210',null,null);
  352. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30433','201','130','130','230',null,null);
  353. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32779','201','180','150','260',null,null);
  354. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32861','201','132','80','140',null,null);
  355. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50169','201','225','220','385',null,null);
  356. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50273','201','75','60','100',null,null);
  357. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50417','201','82','60','100',null,null);
  358. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50418','201','98','60','100',null,null);
  359. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50419','201','77','60','100',null,null);
  360. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50530','201','62','60','100',null,null);
  361. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50532','201','67','60','100',null,null);
  362. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50536','201','97','60','100',null,null);
  363. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20510','301','69','40','100',null,null);
  364. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20512','301','28','20','50',null,null);
  365. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30321','301','85','80','140',null,null);
  366. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30421','301','102','80','140',null,null);
  367. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30433','301','35','20','35',null,null);
  368. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32779','301','102','95','175',null,null);
  369. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32861','301','57','50','100',null,null);
  370. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40421','301','70','40','70',null,null);
  371. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40422','301','65','40','70',null,null);
  372. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41010','301','59','40','70',null,null);
  373. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41020','301','61','40','70',null,null);
  374. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41050','301','49','40','70',null,null);
  375. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41080','301','50','40','70',null,null);
  376. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41100','301','42','40','70',null,null);
  377. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20510','401','88','50','100',null,null);
  378. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20512','401','75','75','140',null,null);
  379. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30321','401','102','80','140',null,null);
  380. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30326','401','113','80','140',null,null);
  381. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30421','401','85','80','140',null,null);
  382. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30426','401','135','80','140',null,null);
  383. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30433','401','0','100','175','A defective shipment was sent to Hong Kong and needed to be returned. The soonest ACME can turn this around is early February.',to_date('92/09/07','RR/MM/DD'));
  384. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32779','401','135','100','175',null,null);
  385. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32861','401','250','150','250',null,null);
  386. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40421','401','47','40','70',null,null);
  387. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40422','401','50','40','70',null,null);
  388. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41010','401','80','70','220',null,null);
  389. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41020','401','91','70','220',null,null);
  390. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41050','401','169','70','220',null,null);
  391. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41080','401','100','70','220',null,null);
  392. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41100','401','75','70','220',null,null);
  393. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50169','401','240','200','350',null,null);
  394. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50273','401','224','150','280',null,null);
  395. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50417','401','130','120','210',null,null);
  396. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50418','401','156','100','175',null,null);
  397. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50419','401','151','150','280',null,null);
  398. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50530','401','119','100','175',null,null);
  399. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50532','401','233','200','350',null,null);
  400. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('50536','401','138','100','175',null,null);
  401. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10012','10501','300','300','525',null,null);
  402. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10013','10501','314','300','525',null,null);
  403. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10022','10501','502','300','525',null,null);
  404. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('10023','10501','500','300','525',null,null);
  405. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20106','10501','150','100','175',null,null);
  406. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20108','10501','222','200','350',null,null);
  407. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20201','10501','275','200','350',null,null);
  408. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20510','10501','57','50','87',null,null);
  409. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('20512','10501','62','50','87',null,null);
  410. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30321','10501','194','150','275',null,null);
  411. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30326','10501','277','250','440',null,null);
  412. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30421','10501','190','150','275',null,null);
  413. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30426','10501','423','250','450',null,null);
  414. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('30433','10501','273','200','350',null,null);
  415. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32779','10501','280','200','350',null,null);
  416. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('32861','10501','288','200','350',null,null);
  417. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40421','10501','97','80','140',null,null);
  418. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('40422','10501','90','80','140',null,null);
  419. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41010','10501','151','140','245',null,null);
  420. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41020','10501','224','140','245',null,null);
  421. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41050','10501','157','140','245',null,null);
  422. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41080','10501','159','140','245',null,null);
  423. Insert into "2955".S_INVENTORY (PRODUCT_ID,WAREHOUSE_ID,AMOUNT_IN_STOCK,REORDER_POINT,MAX_IN_STOCK,OUT_OF_STOCK_EXPLANATION,RESTOCK_DATE) values ('41100','10501','141','140','245',null,null);
  424. REM INSERTING into "2955".S_ITEM
  425. SET DEFINE OFF;
  426. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('100','1','10011','135','500','500');
  427. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('100','2','10013','380','400','400');
  428. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('100','3','10021','14','500','500');
  429. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('100','5','30326','582','600','600');
  430. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('100','7','41010','8','250','250');
  431. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('100','6','30433','20','450','450');
  432. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('100','4','10023','36','400','400');
  433. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('101','1','30421','16','15','15');
  434. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('101','3','41010','8','20','20');
  435. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('101','5','50169','4,29','40','40');
  436. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('101','6','50417','80','27','27');
  437. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('101','7','50530','45','50','50');
  438. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('101','4','41100','45','35','35');
  439. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('101','2','40422','50','30','30');
  440. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('102','1','20108','28','100','100');
  441. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('102','2','20201','123','45','45');
  442. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('103','1','30433','20','15','15');
  443. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('103','2','32779','7','11','11');
  444. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('104','1','20510','9','7','7');
  445. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('104','4','30421','16','35','35');
  446. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('104','2','20512','8','12','12');
  447. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('104','3','30321','1669','19','19');
  448. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('105','1','50273','22,89','16','16');
  449. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('105','3','50532','47','28','28');
  450. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('105','2','50419','80','13','13');
  451. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('106','1','20108','28','46','46');
  452. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('106','4','50273','22,89','75','75');
  453. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('106','5','50418','75','98','98');
  454. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('106','6','50419','80','27','27');
  455. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('106','2','20201','123','21','21');
  456. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('106','3','50169','4,29','125','125');
  457. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('107','1','20106','11','50','50');
  458. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('107','3','20201','115','130','130');
  459. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('107','5','30421','16','55','55');
  460. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('107','4','30321','1669','75','75');
  461. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('107','2','20108','28','22','22');
  462. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('108','1','20510','9','9','9');
  463. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('108','6','41080','35','50','50');
  464. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('108','7','41100','45','42','42');
  465. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('108','5','32861','60','57','57');
  466. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('108','2','20512','8','18','18');
  467. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('108','4','32779','7','60','60');
  468. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('108','3','30321','1669','85','85');
  469. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('109','1','10011','140','150','150');
  470. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('109','5','30426','18,25','500','500');
  471. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('109','7','50418','75','43','43');
  472. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('109','6','32861','60','50','50');
  473. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('109','4','30326','582','1500','1500');
  474. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('109','2','10012','175','600','600');
  475. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('109','3','10022','21,95','300','300');
  476. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('110','1','50273','22,89','17','17');
  477. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('110','2','50536','50','23','23');
  478. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('111','1','40421','65','27','27');
  479. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('111','2','41080','35','29','29');
  480. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('97','1','20106','9','1000','1000');
  481. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('97','2','30321','1500','50','50');
  482. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('98','1','40421','85','7','7');
  483. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('99','1','20510','9','18','18');
  484. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('99','2','20512','8','25','25');
  485. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('99','3','50417','80','53','53');
  486. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('99','4','50530','45','69','69');
  487. Insert into "2955".S_ITEM (ORD_ID,ITEM_ID,PRODUCT_ID,PRICE,QUANTITY,QUANTITY_SHIPPED) values ('112','1','20106','11','50','50');
  488. REM INSERTING into "2955".S_LARGE_EMP
  489. SET DEFINE OFF;
  490. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('1','Velasquez','Carmen','cvelasqu',to_date('90/03/03','RR/MM/DD'),null,null,'President','50','2500',null,'1-206-104-0103','281 King Street','Seattle','Washington','USA','98101',to_date('55/01/08','RR/MM/DD'),null,null);
  491. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('2','Ngao','LaDoris','lngao',to_date('90/03/08','RR/MM/DD'),null,'1','VP, Operations','41','1450',null,null,null,null,null,null,null,null,null,null);
  492. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('3','Nagayama','Midori','mnagayam',to_date('91/06/17','RR/MM/DD'),null,'1','VP, Sales','31','1400',null,null,null,null,null,null,null,null,null,null);
  493. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('4','Quick-To-See','Mark','mquickto',to_date('90/04/07','RR/MM/DD'),null,'1','VP, Finance','10','1450',null,null,null,null,null,null,null,null,null,null);
  494. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('5','Ropeburn','Audry','aropebur',to_date('90/03/04','RR/MM/DD'),null,'1','VP, Administration','50','1550',null,null,null,null,null,null,null,null,null,null);
  495. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('6','Urguhart','Molly','murguhar',to_date('91/01/18','RR/MM/DD'),null,'2','Warehouse Manager','41','1200',null,null,null,null,null,null,null,null,null,null);
  496. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('7','Menchu','Roberta','rmenchu',to_date('90/05/14','RR/MM/DD'),null,'2','Warehouse Manager','42','1250',null,null,null,null,null,null,null,null,null,null);
  497. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('8','Biri','Ben','bbiri',to_date('90/04/07','RR/MM/DD'),null,'2','Warehouse Manager','43','1100',null,null,null,null,null,null,null,null,null,null);
  498. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('9','Catchpole','Antoinette','acatchpo',to_date('92/02/09','RR/MM/DD'),null,'2','Warehouse Manager','44','1300',null,null,null,null,null,null,null,null,null,null);
  499. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('10','Havel','Marta','mhavel',to_date('91/02/27','RR/MM/DD'),null,'2','Warehouse Manager','45','1307',null,null,null,null,null,null,null,null,null,null);
  500. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('11','Magee','Colin','cmagee',to_date('90/05/14','RR/MM/DD'),null,'3','Sales Representative','31','1400','10',null,null,null,null,null,null,null,null,null);
  501. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('12','Giljum','Henry','hgiljum',to_date('92/01/18','RR/MM/DD'),null,'3','Sales Representative','32','1490','12,5',null,null,null,null,null,null,null,null,null);
  502. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('13','Sedeghi','Yasmin','ysedeghi',to_date('91/02/18','RR/MM/DD'),null,'3','Sales Representative','33','1515','10',null,null,null,null,null,null,null,null,null);
  503. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('14','Nguyen','Mai','mnguyen',to_date('92/01/22','RR/MM/DD'),null,'3','Sales Representative','34','1525','15',null,null,null,null,null,null,null,null,null);
  504. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('15','Dumas','Andre','adumas',to_date('91/10/09','RR/MM/DD'),null,'3','Sales Representative','35','1450','17,5',null,null,null,null,null,null,null,null,null);
  505. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('16','Maduro','Elena','emaduro',to_date('92/02/07','RR/MM/DD'),null,'6','Stock Clerk','41','1400',null,null,null,null,null,null,null,null,null,null);
  506. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('17','Smith','George','gsmith',to_date('90/03/08','RR/MM/DD'),null,'6','Stock Clerk','41','940',null,null,null,null,null,null,null,null,null,null);
  507. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('18','Nozaki','Akira','anozaki',to_date('91/02/09','RR/MM/DD'),null,'7','Stock Clerk','42','1200',null,null,null,null,null,null,null,null,null,null);
  508. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('19','Patel','Vikram','vpatel',to_date('91/08/06','RR/MM/DD'),null,'7','Stock Clerk','42','795',null,null,null,null,null,null,null,null,null,null);
  509. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('20','Newman','Chad','cnewman',to_date('91/07/21','RR/MM/DD'),null,'8','Stock Clerk','43','750',null,null,null,null,null,null,null,null,null,null);
  510. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('21','Markarian','Alexander','amarkari',to_date('91/05/26','RR/MM/DD'),null,'8','Stock Clerk','43','850',null,null,null,null,null,null,null,null,null,null);
  511. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('22','Chang','Eddie','echang',to_date('90/11/30','RR/MM/DD'),null,'9','Stock Clerk','44','800',null,null,null,null,null,null,null,null,null,null);
  512. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('23','Patel','Radha','rpatel',to_date('90/10/17','RR/MM/DD'),null,'9','Stock Clerk','34','795',null,null,null,null,null,null,null,null,null,null);
  513. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('24','Dancs','Bela','bdancs',to_date('91/03/17','RR/MM/DD'),null,'10','Stock Clerk','45','860',null,null,null,null,null,null,null,null,null,null);
  514. Insert into "2955".S_LARGE_EMP (ID,LAST_NAME,FIRST_NAME,USERID,START_DATE,COMMENTS,MANAGER_ID,TITLE,DEPT_ID,SALARY,COMMISSION_PCT,PHONE,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,BIRTH_DATE,ROOM_PHONE,ROOM_NO) values ('25','Schwartz','Sylvie','sschwart',to_date('91/05/09','RR/MM/DD'),null,'10','Stock Clerk','45','1100',null,null,null,null,null,null,null,null,null,null);
  515. REM INSERTING into "2955".S_LONGTEXT
  516. SET DEFINE OFF;
  517. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('1017','N',null,'Protective knee pads for any number of physical activities including bicycling and skating (4-wheel, in-line, and ice).  Also provide support for stress activities such as weight-lifting.  Velcro belts allow easy adjustment for any size and snugness of fit.  Hardened plastic shell comes in a variety of colors, so you can buy a pair to match every outfit.  Can also be worn at the beach to cover particularly ugly knees.');
  518. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('1019','N',null,'Protective elbow pads for any number of physical activities including bicycling and skating (4-wheel, in-line, and ice).  Also provide support for stress activities such as weight-lifting.  Velcro belts allow easy adjustment for any size and snugness of fit.  Hardened plastic shell comes in a variety of colors, so you can buy a pair to match every outfit.');
  519. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('1037',null,null,null);
  520. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('1039',null,null,null);
  521. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('1043',null,null,null);
  522. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('1286','N',null,'Don''t slack off--try the Slaker Water Bottle.  With its 1 quart capacity, this is the only water bottle you''ll need.  It''s lightweight, durable, and guaranteed for life to be leak proof.  It comes with a convenient velcro strap so it can be conveniently attached to your bike or other sports equipment.');
  523. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('1368',null,null,null);
  524. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('517',null,null,null);
  525. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('518','N',null,'Perfect for the beginner.  Rear entry (easy to put on with only one buckle), weight control adjustment on side of boot for easy access, comes in a wide variety of colors to match every outfit.');
  526. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('519','N',null,'If you have mastered the basic techniques you are ready for the Ace Ski Boot.  This intermediate boot comes as a package with self adjustable bindings that will adapt to your skill and speed. The boot is designed for extra grip on slopes and jumps.');
  527. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('520','N',null,'The Pro ski boot is an advanced boot that combines high tech and comfort.  It''s made of fibre that will mould to your foot with body heat.  If you''re after perfection, don''t look any further: this is it!');
  528. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('527',null,null,null);
  529. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('528','N',null,'Lightweight aluminum pole, comes in a variety of sizes and neon colors.  Comfortable adjustable straps.');
  530. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('529',null,null,null);
  531. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('530',null,null,null);
  532. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('557',null,null,null);
  533. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('587',null,null,null);
  534. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('607',null,null,null);
  535. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('613',null,null,null);
  536. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('615',null,null,null);
  537. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('676',null,null,null);
  538. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('708',null,null,null);
  539. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('780',null,null,null);
  540. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('828',null,null,null);
  541. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('833',null,null,null);
  542. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('924',null,null,null);
  543. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('925',null,null,null);
  544. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('926',null,null,null);
  545. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('927',null,null,null);
  546. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('928',null,null,null);
  547. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('929',null,null,null);
  548. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('933','N',null,'The widest, strongest, and knobbiest tires for mountain bike enthusiasts.  Guaranteed to withstand pummelling that will reduce most bicycles (except for the Himalayan) to scrap iron.  These tires can carry you to places where nobody would want to bicycle.  Sizes to fit all makes of mountain bike including wide and super wide rims.  Steel-banded radial models are also available by direct factory order.');
  549. Insert into "2955".S_LONGTEXT (ID,USE_FILENAME,FILENAME,TEXT) values ('940',null,null,null);
  550. REM INSERTING into "2955".S_ORD
  551. SET DEFINE OFF;
  552. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('100','204',to_date('92/08/31','RR/MM/DD'),to_date('92/09/10','RR/MM/DD'),'11','601100','CREDIT','Y');
  553. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('101','205',to_date('92/08/31','RR/MM/DD'),to_date('92/09/15','RR/MM/DD'),'14','8056,6','CREDIT','Y');
  554. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('102','206',to_date('92/09/01','RR/MM/DD'),to_date('92/09/08','RR/MM/DD'),'15','8335','CREDIT','Y');
  555. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('103','208',to_date('92/09/02','RR/MM/DD'),to_date('92/09/22','RR/MM/DD'),'15','377','CASH','Y');
  556. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('104','208',to_date('92/09/03','RR/MM/DD'),to_date('92/09/23','RR/MM/DD'),'15','32430','CREDIT','Y');
  557. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('105','209',to_date('92/09/04','RR/MM/DD'),to_date('92/09/18','RR/MM/DD'),'11','2722,24','CREDIT','Y');
  558. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('106','210',to_date('92/09/07','RR/MM/DD'),to_date('92/09/15','RR/MM/DD'),'12','15634','CREDIT','Y');
  559. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('107','211',to_date('92/09/07','RR/MM/DD'),to_date('92/09/21','RR/MM/DD'),'15','142171','CREDIT','Y');
  560. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('108','212',to_date('92/09/07','RR/MM/DD'),to_date('92/09/10','RR/MM/DD'),'13','149570','CREDIT','Y');
  561. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('109','213',to_date('92/09/08','RR/MM/DD'),to_date('92/09/28','RR/MM/DD'),'11','1020935','CREDIT','Y');
  562. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('110','214',to_date('92/09/09','RR/MM/DD'),to_date('92/09/21','RR/MM/DD'),'11','1539,13','CASH','Y');
  563. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('111','204',to_date('92/09/09','RR/MM/DD'),to_date('92/09/21','RR/MM/DD'),'11','2770','CASH','Y');
  564. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('97','201',to_date('92/08/28','RR/MM/DD'),to_date('92/09/17','RR/MM/DD'),'12','84000','CREDIT','Y');
  565. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('98','202',to_date('92/08/31','RR/MM/DD'),to_date('92/09/10','RR/MM/DD'),'14','595','CASH','Y');
  566. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('99','203',to_date('92/08/31','RR/MM/DD'),to_date('92/09/18','RR/MM/DD'),'14','7707','CREDIT','Y');
  567. Insert into "2955".S_ORD (ID,CUSTOMER_ID,DATE_ORDERED,DATE_SHIPPED,SALES_REP_ID,TOTAL,PAYMENT_TYPE,ORDER_FILLED) values ('112','210',to_date('92/08/31','RR/MM/DD'),to_date('92/09/10','RR/MM/DD'),'12','550','CREDIT','Y');
  568. REM INSERTING into "2955".S_PRODUCT
  569. SET DEFINE OFF;
  570. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('10011','Bunny Boot','Beginner''s ski boot','518','1001','150',null);
  571. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('10012','Ace Ski Boot','Intermediate ski boot','519','1002','200',null);
  572. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('10013','Pro Ski Boot','Advanced ski boot','520','1003','410',null);
  573. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('10021','Bunny Ski Pole','Beginner''s ski pole','528','1011','16,25',null);
  574. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('10022','Ace Ski Pole','Intermediate ski pole','529','1012','21,95',null);
  575. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('10023','Pro Ski Pole','Advanced ski pole','530','1013','40,95',null);
  576. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('20106','Junior Soccer Ball','Junior soccer ball','613',null,'11',null);
  577. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('20108','World Cup Soccer Ball','World cup soccer ball','615',null,'28',null);
  578. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('20201','World Cup Net','World cup net','708',null,'123',null);
  579. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('20510','Black Hawk Knee Pads','Knee pads, pair','1017',null,'9',null);
  580. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('20512','Black Hawk Elbow Pads','Elbow pads, pair','1019',null,'8',null);
  581. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('30321','Grand Prix Bicycle','Road bicycle','828','1291','1669',null);
  582. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('30326','Himalaya Bicycle','Mountain bicycle','833','1296','582',null);
  583. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('30421','Grand Prix Bicycle Tires','Road bicycle tires','927',null,'16',null);
  584. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('30426','Himalaya Tires','Mountain bicycle tires','933',null,'18,25',null);
  585. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('30433','New Air Pump','Tire pump','940',null,'20',null);
  586. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('32779','Slaker Water Bottle','Water bottle','1286',null,'7',null);
  587. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('32861','Safe-T Helmet','Bicycle helmet','1368','1829','60',null);
  588. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('40421','Alexeyer Pro Lifting Bar','Straight bar','928','1381','65',null);
  589. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('40422','Pro Curling Bar','Curling bar','929','1382','50',null);
  590. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('41010','Prostar 10 Pound Weight','Ten pound weight','517',null,'8',null);
  591. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('41020','Prostar 20 Pound Weight','Twenty pound weight','527',null,'12',null);
  592. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('41050','Prostar 50 Pound Weight','Fifty pound weight','557',null,'25',null);
  593. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('41080','Prostar 80 Pound Weight','Eighty pound weight','587',null,'35',null);
  594. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('41100','Prostar 100 Pound Weight','One hundred pound weight','607',null,'45',null);
  595. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50169','Major League Baseball','Baseball','676','1119','4,29',null);
  596. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50273','Chapman Helmet','Batting helmet','780','1223','22,89',null);
  597. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50417','Griffey Glove','Outfielder''s glove','924','1367','80',null);
  598. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50418','Alomar Glove','Infielder''s glove','925','1368','75',null);
  599. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50419','Steinbach Glove','Catcher''s glove','926','1369','80',null);
  600. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50530','Cabrera Bat','Thirty inch bat','1037','1480','45',null);
  601. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50532','Puckett Bat','Thirty-two inch bat','1039','1482','47',null);
  602. Insert into "2955".S_PRODUCT (ID,NAME,SHORT_DESC,LONGTEXT_ID,IMAGE_ID,SUGGESTED_WHLSL_PRICE,WHLSL_UNITS) values ('50536','Winfield Bat','Thirty-six inch bat','1043','1486','50',null);
  603. REM INSERTING into "2955".S_REGION
  604. SET DEFINE OFF;
  605. Insert into "2955".S_REGION (ID,NAME) values ('3','Africa / Middle East');
  606. Insert into "2955".S_REGION (ID,NAME) values ('4','Asia');
  607. Insert into "2955".S_REGION (ID,NAME) values ('5','Europe');
  608. Insert into "2955".S_REGION (ID,NAME) values ('1','North America');
  609. Insert into "2955".S_REGION (ID,NAME) values ('2','South America');
  610. REM INSERTING into "2955".S_TITLE
  611. SET DEFINE OFF;
  612. Insert into "2955".S_TITLE (TITLE) values ('President');
  613. Insert into "2955".S_TITLE (TITLE) values ('Sales Representative');
  614. Insert into "2955".S_TITLE (TITLE) values ('Stock Clerk');
  615. Insert into "2955".S_TITLE (TITLE) values ('VP, Administration');
  616. Insert into "2955".S_TITLE (TITLE) values ('VP, Finance');
  617. Insert into "2955".S_TITLE (TITLE) values ('VP, Operations');
  618. Insert into "2955".S_TITLE (TITLE) values ('VP, Sales');
  619. Insert into "2955".S_TITLE (TITLE) values ('Warehouse Manager');
  620. REM INSERTING into "2955".S_WAREHOUSE
  621. SET DEFINE OFF;
  622. Insert into "2955".S_WAREHOUSE (ID,REGION_ID,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,PHONE,MANAGER_ID) values ('101','1','283 King Street','Seattle','WA','USA',null,null,'6');
  623. Insert into "2955".S_WAREHOUSE (ID,REGION_ID,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,PHONE,MANAGER_ID) values ('10501','5','5 Modrany','Bratislava',null,'Czechozlovakia',null,null,'10');
  624. Insert into "2955".S_WAREHOUSE (ID,REGION_ID,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,PHONE,MANAGER_ID) values ('201','2','68 Via Centrale','Sao Paolo',null,'Brazil',null,null,'7');
  625. Insert into "2955".S_WAREHOUSE (ID,REGION_ID,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,PHONE,MANAGER_ID) values ('301','3','6921 King Way','Lagos',null,'Nigeria',null,null,'8');
  626. Insert into "2955".S_WAREHOUSE (ID,REGION_ID,ADDRESS,CITY,STATE,COUNTRY,ZIP_CODE,PHONE,MANAGER_ID) values ('401','4','86 Chu Street','Hong Kong',null,null,null,null,'9');
  627. --------------------------------------------------------
  628. --  DDL for Index S_CUSTOMER_ID_PK
  629. --------------------------------------------------------
  630.  
  631.   CREATE UNIQUE INDEX "2955"."S_CUSTOMER_ID_PK" ON "2955"."S_CUSTOMER" ("ID")
  632.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  633.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  634.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  635.   TABLESPACE "AB" ;
  636. --------------------------------------------------------
  637. --  DDL for Index S_DEPT_ID_PK
  638. --------------------------------------------------------
  639.  
  640.   CREATE UNIQUE INDEX "2955"."S_DEPT_ID_PK" ON "2955"."S_DEPT" ("ID")
  641.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  642.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  643.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  644.   TABLESPACE "AB" ;
  645. --------------------------------------------------------
  646. --  DDL for Index S_DEPT_NAME_REGION_ID_UK
  647. --------------------------------------------------------
  648.  
  649.   CREATE UNIQUE INDEX "2955"."S_DEPT_NAME_REGION_ID_UK" ON "2955"."S_DEPT" ("NAME", "REGION_ID")
  650.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  651.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  652.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  653.   TABLESPACE "AB" ;
  654. --------------------------------------------------------
  655. --  DDL for Index S_EMP_ID_PK
  656. --------------------------------------------------------
  657.  
  658.   CREATE UNIQUE INDEX "2955"."S_EMP_ID_PK" ON "2955"."S_EMP" ("ID")
  659.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  660.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  661.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  662.   TABLESPACE "AB" ;
  663. --------------------------------------------------------
  664. --  DDL for Index S_EMP_USERID_UK
  665. --------------------------------------------------------
  666.  
  667.   CREATE UNIQUE INDEX "2955"."S_EMP_USERID_UK" ON "2955"."S_EMP" ("USERID")
  668.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  669.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  670.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  671.   TABLESPACE "AB" ;
  672. --------------------------------------------------------
  673. --  DDL for Index S_IMAGE_ID_PK
  674. --------------------------------------------------------
  675.  
  676.   CREATE UNIQUE INDEX "2955"."S_IMAGE_ID_PK" ON "2955"."S_IMAGE" ("ID")
  677.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  678.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  679.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  680.   TABLESPACE "AB" ;
  681. --------------------------------------------------------
  682. --  DDL for Index S_INVENTORY_PRODID_WARID_PK
  683. --------------------------------------------------------
  684.  
  685.   CREATE UNIQUE INDEX "2955"."S_INVENTORY_PRODID_WARID_PK" ON "2955"."S_INVENTORY" ("PRODUCT_ID", "WAREHOUSE_ID")
  686.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  687.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  688.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  689.   TABLESPACE "AB" ;
  690. --------------------------------------------------------
  691. --  DDL for Index S_ITEM_ORDID_ITEMID_PK
  692. --------------------------------------------------------
  693.  
  694.   CREATE UNIQUE INDEX "2955"."S_ITEM_ORDID_ITEMID_PK" ON "2955"."S_ITEM" ("ORD_ID", "ITEM_ID")
  695.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  696.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  697.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  698.   TABLESPACE "AB" ;
  699. --------------------------------------------------------
  700. --  DDL for Index S_ITEM_ORDID_PRODID_UK
  701. --------------------------------------------------------
  702.  
  703.   CREATE UNIQUE INDEX "2955"."S_ITEM_ORDID_PRODID_UK" ON "2955"."S_ITEM" ("ORD_ID", "PRODUCT_ID")
  704.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  705.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  706.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  707.   TABLESPACE "AB" ;
  708. --------------------------------------------------------
  709. --  DDL for Index S_LONGTEXT_ID_PK
  710. --------------------------------------------------------
  711.  
  712.   CREATE UNIQUE INDEX "2955"."S_LONGTEXT_ID_PK" ON "2955"."S_LONGTEXT" ("ID")
  713.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  714.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  715.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  716.   TABLESPACE "AB" ;
  717. --------------------------------------------------------
  718. --  DDL for Index S_ORD_ID_PK
  719. --------------------------------------------------------
  720.  
  721.   CREATE UNIQUE INDEX "2955"."S_ORD_ID_PK" ON "2955"."S_ORD" ("ID")
  722.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  723.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  724.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  725.   TABLESPACE "AB" ;
  726. --------------------------------------------------------
  727. --  DDL for Index S_PRODUCT_ID_PK
  728. --------------------------------------------------------
  729.  
  730.   CREATE UNIQUE INDEX "2955"."S_PRODUCT_ID_PK" ON "2955"."S_PRODUCT" ("ID")
  731.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  732.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  733.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  734.   TABLESPACE "AB" ;
  735. --------------------------------------------------------
  736. --  DDL for Index S_PRODUCT_NAME_UK
  737. --------------------------------------------------------
  738.  
  739.   CREATE UNIQUE INDEX "2955"."S_PRODUCT_NAME_UK" ON "2955"."S_PRODUCT" ("NAME")
  740.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  741.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  742.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  743.   TABLESPACE "AB" ;
  744. --------------------------------------------------------
  745. --  DDL for Index S_REGION_ID_PK
  746. --------------------------------------------------------
  747.  
  748.   CREATE UNIQUE INDEX "2955"."S_REGION_ID_PK" ON "2955"."S_REGION" ("ID")
  749.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  750.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  751.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  752.   TABLESPACE "AB" ;
  753. --------------------------------------------------------
  754. --  DDL for Index S_REGION_NAME_UK
  755. --------------------------------------------------------
  756.  
  757.   CREATE UNIQUE INDEX "2955"."S_REGION_NAME_UK" ON "2955"."S_REGION" ("NAME")
  758.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  759.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  760.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  761.   TABLESPACE "AB" ;
  762. --------------------------------------------------------
  763. --  DDL for Index S_TITLE_TITLE_PK
  764. --------------------------------------------------------
  765.  
  766.   CREATE UNIQUE INDEX "2955"."S_TITLE_TITLE_PK" ON "2955"."S_TITLE" ("TITLE")
  767.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  768.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  769.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  770.   TABLESPACE "AB" ;
  771. --------------------------------------------------------
  772. --  DDL for Index S_WAREHOUSE_ID_PK
  773. --------------------------------------------------------
  774.  
  775.   CREATE UNIQUE INDEX "2955"."S_WAREHOUSE_ID_PK" ON "2955"."S_WAREHOUSE" ("ID")
  776.   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  777.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  778.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  779.   TABLESPACE "AB" ;
  780. --------------------------------------------------------
  781. --  Constraints for Table S_CUSTOMER
  782. --------------------------------------------------------
  783.  
  784.   ALTER TABLE "2955"."S_CUSTOMER" ADD CONSTRAINT "S_CUSTOMER_CREDIT_RATING_CK" CHECK (credit_rating IN ('EXCELLENT', 'GOOD', 'POOR')) ENABLE;
  785.  
  786.   ALTER TABLE "2955"."S_CUSTOMER" MODIFY ("ID" CONSTRAINT "S_CUSTOMER_ID_NN" NOT NULL ENABLE);
  787.  
  788.   ALTER TABLE "2955"."S_CUSTOMER" ADD CONSTRAINT "S_CUSTOMER_ID_PK" PRIMARY KEY ("ID")
  789.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  790.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  791.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  792.   TABLESPACE "AB"  ENABLE;
  793.  
  794.   ALTER TABLE "2955"."S_CUSTOMER" MODIFY ("NAME" CONSTRAINT "S_CUSTOMER_NAME_NN" NOT NULL ENABLE);
  795. --------------------------------------------------------
  796. --  Constraints for Table S_DEPT
  797. --------------------------------------------------------
  798.  
  799.   ALTER TABLE "2955"."S_DEPT" MODIFY ("ID" CONSTRAINT "S_DEPT_ID_NN" NOT NULL ENABLE);
  800.  
  801.   ALTER TABLE "2955"."S_DEPT" ADD CONSTRAINT "S_DEPT_ID_PK" PRIMARY KEY ("ID")
  802.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  803.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  804.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  805.   TABLESPACE "AB"  ENABLE;
  806.  
  807.   ALTER TABLE "2955"."S_DEPT" MODIFY ("NAME" CONSTRAINT "S_DEPT_NAME_NN" NOT NULL ENABLE);
  808.  
  809.   ALTER TABLE "2955"."S_DEPT" ADD CONSTRAINT "S_DEPT_NAME_REGION_ID_UK" UNIQUE ("NAME", "REGION_ID")
  810.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  811.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  812.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  813.   TABLESPACE "AB"  ENABLE;
  814. --------------------------------------------------------
  815. --  Constraints for Table S_EMP
  816. --------------------------------------------------------
  817.  
  818.   ALTER TABLE "2955"."S_EMP" ADD CONSTRAINT "S_EMP_COMMISSION_PCT_CK" CHECK (commission_pct IN (10, 12.5, 15, 17.5, 20)) ENABLE;
  819.  
  820.   ALTER TABLE "2955"."S_EMP" MODIFY ("ID" CONSTRAINT "S_EMP_ID_NN" NOT NULL ENABLE);
  821.  
  822.   ALTER TABLE "2955"."S_EMP" ADD CONSTRAINT "S_EMP_ID_PK" PRIMARY KEY ("ID")
  823.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  824.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  825.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  826.   TABLESPACE "AB"  ENABLE;
  827.  
  828.   ALTER TABLE "2955"."S_EMP" MODIFY ("LAST_NAME" CONSTRAINT "S_EMP_LAST_NAME_NN" NOT NULL ENABLE);
  829.  
  830.   ALTER TABLE "2955"."S_EMP" ADD CONSTRAINT "S_EMP_USERID_UK" UNIQUE ("USERID")
  831.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  832.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  833.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  834.   TABLESPACE "AB"  ENABLE;
  835. --------------------------------------------------------
  836. --  Constraints for Table S_IMAGE
  837. --------------------------------------------------------
  838.  
  839.   ALTER TABLE "2955"."S_IMAGE" ADD CONSTRAINT "S_IMAGE_FORMAT_CK" CHECK (format in ('JFIFF', 'JTIFF')) ENABLE;
  840.  
  841.   ALTER TABLE "2955"."S_IMAGE" MODIFY ("ID" CONSTRAINT "S_IMAGE_ID_NN" NOT NULL ENABLE);
  842.  
  843.   ALTER TABLE "2955"."S_IMAGE" ADD CONSTRAINT "S_IMAGE_ID_PK" PRIMARY KEY ("ID")
  844.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  845.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  846.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  847.   TABLESPACE "AB"  ENABLE;
  848.  
  849.   ALTER TABLE "2955"."S_IMAGE" ADD CONSTRAINT "S_IMAGE_USE_FILENAME_CK" CHECK (use_filename in ('Y', 'N')) ENABLE;
  850. --------------------------------------------------------
  851. --  Constraints for Table S_INVENTORY
  852. --------------------------------------------------------
  853.  
  854.   ALTER TABLE "2955"."S_INVENTORY" ADD CONSTRAINT "S_INVENTORY_PRODID_WARID_PK" PRIMARY KEY ("PRODUCT_ID", "WAREHOUSE_ID")
  855.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  856.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  857.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  858.   TABLESPACE "AB"  ENABLE;
  859.  
  860.   ALTER TABLE "2955"."S_INVENTORY" MODIFY ("PRODUCT_ID" CONSTRAINT "S_INVENTORY_PRODUCT_ID_NN" NOT NULL ENABLE);
  861.  
  862.   ALTER TABLE "2955"."S_INVENTORY" MODIFY ("WAREHOUSE_ID" CONSTRAINT "S_INVENTORY_WAREHOUSE_ID_NN" NOT NULL ENABLE);
  863. --------------------------------------------------------
  864. --  Constraints for Table S_ITEM
  865. --------------------------------------------------------
  866.  
  867.   ALTER TABLE "2955"."S_ITEM" MODIFY ("ITEM_ID" CONSTRAINT "S_ITEM_ITEM_ID_NN" NOT NULL ENABLE);
  868.  
  869.   ALTER TABLE "2955"."S_ITEM" ADD CONSTRAINT "S_ITEM_ORDID_ITEMID_PK" PRIMARY KEY ("ORD_ID", "ITEM_ID")
  870.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  871.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  872.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  873.   TABLESPACE "AB"  ENABLE;
  874.  
  875.   ALTER TABLE "2955"."S_ITEM" ADD CONSTRAINT "S_ITEM_ORDID_PRODID_UK" UNIQUE ("ORD_ID", "PRODUCT_ID")
  876.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  877.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  878.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  879.   TABLESPACE "AB"  ENABLE;
  880.  
  881.   ALTER TABLE "2955"."S_ITEM" MODIFY ("ORD_ID" CONSTRAINT "S_ITEM_ORD_ID_NN" NOT NULL ENABLE);
  882.  
  883.   ALTER TABLE "2955"."S_ITEM" MODIFY ("PRODUCT_ID" CONSTRAINT "S_ITEM_PRODUCT_ID_NN" NOT NULL ENABLE);
  884. --------------------------------------------------------
  885. --  Constraints for Table S_LARGE_EMP
  886. --------------------------------------------------------
  887.  
  888.   ALTER TABLE "2955"."S_LARGE_EMP" MODIFY ("ID" NOT NULL ENABLE);
  889.  
  890.   ALTER TABLE "2955"."S_LARGE_EMP" MODIFY ("LAST_NAME" NOT NULL ENABLE);
  891. --------------------------------------------------------
  892. --  Constraints for Table S_LONGTEXT
  893. --------------------------------------------------------
  894.  
  895.   ALTER TABLE "2955"."S_LONGTEXT" MODIFY ("ID" CONSTRAINT "S_LONGTEXT_ID_NN" NOT NULL ENABLE);
  896.  
  897.   ALTER TABLE "2955"."S_LONGTEXT" ADD CONSTRAINT "S_LONGTEXT_ID_PK" PRIMARY KEY ("ID")
  898.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  899.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  900.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  901.   TABLESPACE "AB"  ENABLE;
  902.  
  903.   ALTER TABLE "2955"."S_LONGTEXT" ADD CONSTRAINT "S_LONGTEXT_USE_FILENAME_CK" CHECK (use_filename in ('Y', 'N')) ENABLE;
  904. --------------------------------------------------------
  905. --  Constraints for Table S_ORD
  906. --------------------------------------------------------
  907.  
  908.   ALTER TABLE "2955"."S_ORD" MODIFY ("CUSTOMER_ID" CONSTRAINT "S_ORD_CUSTOMER_ID_NN" NOT NULL ENABLE);
  909.  
  910.   ALTER TABLE "2955"."S_ORD" MODIFY ("ID" CONSTRAINT "S_ORD_ID_NN" NOT NULL ENABLE);
  911.  
  912.   ALTER TABLE "2955"."S_ORD" ADD CONSTRAINT "S_ORD_ID_PK" PRIMARY KEY ("ID")
  913.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  914.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  915.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  916.   TABLESPACE "AB"  ENABLE;
  917.  
  918.   ALTER TABLE "2955"."S_ORD" ADD CONSTRAINT "S_ORD_ORDER_FILLED_CK" CHECK (order_filled in ('Y', 'N')) ENABLE;
  919.  
  920.   ALTER TABLE "2955"."S_ORD" ADD CONSTRAINT "S_ORD_PAYMENT_TYPE_CK" CHECK (payment_type in ('CASH', 'CREDIT')) ENABLE;
  921. --------------------------------------------------------
  922. --  Constraints for Table S_PRODUCT
  923. --------------------------------------------------------
  924.  
  925.   ALTER TABLE "2955"."S_PRODUCT" MODIFY ("ID" CONSTRAINT "S_PRODUCT_ID_NN" NOT NULL ENABLE);
  926.  
  927.   ALTER TABLE "2955"."S_PRODUCT" ADD CONSTRAINT "S_PRODUCT_ID_PK" PRIMARY KEY ("ID")
  928.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  929.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  930.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  931.   TABLESPACE "AB"  ENABLE;
  932.  
  933.   ALTER TABLE "2955"."S_PRODUCT" MODIFY ("NAME" CONSTRAINT "S_PRODUCT_NAME_NN" NOT NULL ENABLE);
  934.  
  935.   ALTER TABLE "2955"."S_PRODUCT" ADD CONSTRAINT "S_PRODUCT_NAME_UK" UNIQUE ("NAME")
  936.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  937.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  938.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  939.   TABLESPACE "AB"  ENABLE;
  940. --------------------------------------------------------
  941. --  Constraints for Table S_REGION
  942. --------------------------------------------------------
  943.  
  944.   ALTER TABLE "2955"."S_REGION" MODIFY ("ID" CONSTRAINT "S_REGION_ID_NN" NOT NULL ENABLE);
  945.  
  946.   ALTER TABLE "2955"."S_REGION" ADD CONSTRAINT "S_REGION_ID_PK" PRIMARY KEY ("ID")
  947.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  948.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  949.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  950.   TABLESPACE "AB"  ENABLE;
  951.  
  952.   ALTER TABLE "2955"."S_REGION" MODIFY ("NAME" CONSTRAINT "S_REGION_NAME_NN" NOT NULL ENABLE);
  953.  
  954.   ALTER TABLE "2955"."S_REGION" ADD CONSTRAINT "S_REGION_NAME_UK" UNIQUE ("NAME")
  955.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  956.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  957.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  958.   TABLESPACE "AB"  ENABLE;
  959. --------------------------------------------------------
  960. --  Constraints for Table S_TITLE
  961. --------------------------------------------------------
  962.  
  963.   ALTER TABLE "2955"."S_TITLE" MODIFY ("TITLE" CONSTRAINT "S_TITLE_TITLE_NN" NOT NULL ENABLE);
  964.  
  965.   ALTER TABLE "2955"."S_TITLE" ADD CONSTRAINT "S_TITLE_TITLE_PK" PRIMARY KEY ("TITLE")
  966.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  967.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  968.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  969.   TABLESPACE "AB"  ENABLE;
  970. --------------------------------------------------------
  971. --  Constraints for Table S_WAREHOUSE
  972. --------------------------------------------------------
  973.  
  974.   ALTER TABLE "2955"."S_WAREHOUSE" MODIFY ("ID" CONSTRAINT "S_WAREHOUSE_ID_NN" NOT NULL ENABLE);
  975.  
  976.   ALTER TABLE "2955"."S_WAREHOUSE" ADD CONSTRAINT "S_WAREHOUSE_ID_PK" PRIMARY KEY ("ID")
  977.   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  978.   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  979.   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  980.   TABLESPACE "AB"  ENABLE;
  981.  
  982.   ALTER TABLE "2955"."S_WAREHOUSE" MODIFY ("REGION_ID" CONSTRAINT "S_WAREHOUSE_REGION_ID_NN" NOT NULL ENABLE);
  983. --------------------------------------------------------
  984. --  Ref Constraints for Table S_CUSTOMER
  985. --------------------------------------------------------
  986.  
  987.   ALTER TABLE "2955"."S_CUSTOMER" ADD CONSTRAINT "S_CUSTOMER_REGION_ID_FK" FOREIGN KEY ("REGION_ID")
  988.       REFERENCES "2955"."S_REGION" ("ID") ENABLE;
  989.  
  990.   ALTER TABLE "2955"."S_CUSTOMER" ADD CONSTRAINT "S_SALES_REP_ID_FK" FOREIGN KEY ("SALES_REP_ID")
  991.       REFERENCES "2955"."S_EMP" ("ID") ENABLE;
  992. --------------------------------------------------------
  993. --  Ref Constraints for Table S_DEPT
  994. --------------------------------------------------------
  995.  
  996.   ALTER TABLE "2955"."S_DEPT" ADD CONSTRAINT "S_DEPT_REGION_ID_FK" FOREIGN KEY ("REGION_ID")
  997.       REFERENCES "2955"."S_REGION" ("ID") ENABLE;
  998. --------------------------------------------------------
  999. --  Ref Constraints for Table S_EMP
  1000. --------------------------------------------------------
  1001.  
  1002.   ALTER TABLE "2955"."S_EMP" ADD CONSTRAINT "S_EMP_DEPT_ID_FK" FOREIGN KEY ("DEPT_ID")
  1003.       REFERENCES "2955"."S_DEPT" ("ID") ENABLE;
  1004.  
  1005.   ALTER TABLE "2955"."S_EMP" ADD CONSTRAINT "S_EMP_MANAGER_ID_FK" FOREIGN KEY ("MANAGER_ID")
  1006.       REFERENCES "2955"."S_EMP" ("ID") ENABLE;
  1007.  
  1008.   ALTER TABLE "2955"."S_EMP" ADD CONSTRAINT "S_EMP_TITLE_FK" FOREIGN KEY ("TITLE")
  1009.       REFERENCES "2955"."S_TITLE" ("TITLE") ENABLE;
  1010.  
  1011. --------------------------------------------------------
  1012. --  Ref Constraints for Table S_INVENTORY
  1013. --------------------------------------------------------
  1014.  
  1015.   ALTER TABLE "2955"."S_INVENTORY" ADD CONSTRAINT "S_INVENTORY_PRODUCT_ID_FK" FOREIGN KEY ("PRODUCT_ID")
  1016.       REFERENCES "2955"."S_PRODUCT" ("ID") ENABLE;
  1017.  
  1018.   ALTER TABLE "2955"."S_INVENTORY" ADD CONSTRAINT "S_INVENTORY_WAREHOUSE_ID_FK" FOREIGN KEY ("WAREHOUSE_ID")
  1019.       REFERENCES "2955"."S_WAREHOUSE" ("ID") ENABLE;
  1020. --------------------------------------------------------
  1021. --  Ref Constraints for Table S_ITEM
  1022. --------------------------------------------------------
  1023.  
  1024.   ALTER TABLE "2955"."S_ITEM" ADD CONSTRAINT "S_ITEM_ORD_ID_FK" FOREIGN KEY ("ORD_ID")
  1025.       REFERENCES "2955"."S_ORD" ("ID") ENABLE;
  1026.  
  1027.   ALTER TABLE "2955"."S_ITEM" ADD CONSTRAINT "S_ITEM_PRODUCT_ID_FK" FOREIGN KEY ("PRODUCT_ID")
  1028.       REFERENCES "2955"."S_PRODUCT" ("ID") ENABLE;
  1029.  
  1030.  
  1031. --------------------------------------------------------
  1032. --  Ref Constraints for Table S_ORD
  1033. --------------------------------------------------------
  1034.  
  1035.   ALTER TABLE "2955"."S_ORD" ADD CONSTRAINT "S_ORD_CUSTOMER_ID_FK" FOREIGN KEY ("CUSTOMER_ID")
  1036.       REFERENCES "2955"."S_CUSTOMER" ("ID") ENABLE;
  1037.  
  1038.   ALTER TABLE "2955"."S_ORD" ADD CONSTRAINT "S_ORD_SALES_REP_ID_FK" FOREIGN KEY ("SALES_REP_ID")
  1039.       REFERENCES "2955"."S_EMP" ("ID") ENABLE;
  1040. --------------------------------------------------------
  1041. --  Ref Constraints for Table S_PRODUCT
  1042. --------------------------------------------------------
  1043.  
  1044.   ALTER TABLE "2955"."S_PRODUCT" ADD CONSTRAINT "S_PRODUCT_IMAGE_ID_FK" FOREIGN KEY ("IMAGE_ID")
  1045.       REFERENCES "2955"."S_IMAGE" ("ID") ENABLE;
  1046.  
  1047.   ALTER TABLE "2955"."S_PRODUCT" ADD CONSTRAINT "S_PRODUCT_LONGTEXT_ID_FK" FOREIGN KEY ("LONGTEXT_ID")
  1048.       REFERENCES "2955"."S_LONGTEXT" ("ID") ENABLE;
  1049.  
  1050.  
  1051. --------------------------------------------------------
  1052. --  Ref Constraints for Table S_WAREHOUSE
  1053. --------------------------------------------------------
  1054.  
  1055.   ALTER TABLE "2955"."S_WAREHOUSE" ADD CONSTRAINT "S_WAREHOUSE_MANAGER_ID_FK" FOREIGN KEY ("MANAGER_ID")
  1056.       REFERENCES "2955"."S_EMP" ("ID") ENABLE;
  1057.  
  1058.   ALTER TABLE "2955"."S_WAREHOUSE" ADD CONSTRAINT "S_WAREHOUSE_REGION_ID_FK" FOREIGN KEY ("REGION_ID")
  1059.       REFERENCES "2955"."S_REGION" ("ID") ENABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!