API tools faq
paste
Advertisement
Guest User

CRScript.sql

a guest
Apr 25th, 2019
121
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 17.39 KB | None | 0 0
raw download clone embed print report
  1. ALTER TABLE CR_Employee DROP CONSTRAINT FKSupEmpNo;
  2. ALTER TABLE CR_Ordertbl DROP CONSTRAINT FKCustNo;
  3. ALTER TABLE CR_Ordertbl DROP CONSTRAINT FKEmpNo;
  4. ALTER TABLE CR_OrdLine DROP CONSTRAINT FKOrdNo;
  5. ALTER TABLE CR_OrdLine DROP CONSTRAINT FKProdNo;
  6.  
  7. ALTER TABLE CR_Customer DROP CONSTRAINT PKCustomer;
  8. ALTER TABLE CR_Product DROP CONSTRAINT PKProduct;
  9. ALTER TABLE CR_Employee DROP CONSTRAINT PKEmployee;
  10. ALTER TABLE CR_OrderTbl DROP CONSTRAINT PKOrderTbl;
  11. ALTER TABLE CR_OrdLine DROP CONSTRAINT PKOrdLine;
  12. DROP TABLE CR_Customer;
  13. DROP TABLE CR_Product;
  14. DROP TABLE CR_Employee;
  15. DROP TABLE CR_OrderTbl;
  16. DROP TABLE CR_OrdLine;
  17.  
  18. CREATE TABLE CR_Customer
  19. (   CustNo          CHAR(8),
  20.         CustFirstName    VARCHAR2(20) CONSTRAINT CustFirstNameRequired NOT NULL,
  21.         CustLastName     VARCHAR2(30) CONSTRAINT CustLastNameRequired NOT NULL,
  22.     CustStreet  VARCHAR2(50),
  23.     CustCity    VARCHAR2(30),
  24.     CustState   CHAR(2),
  25.     CustZip     CHAR(10),
  26.     CustBal     DECIMAL(12,2) DEFAULT 0,
  27.  CONSTRAINT PKCustomer PRIMARY KEY (CustNo)  );
  28.  
  29. CREATE TABLE CR_Product
  30. (   ProdNo           CHAR(8),
  31.     ProdName     VARCHAR2(50) CONSTRAINT ProdNameRequired NOT NULL,
  32.     ProdMfg          VARCHAR2(20) CONSTRAINT ProdMfgRequired NOT NULL,
  33.     ProdQOH          INTEGER,
  34.     ProdPrice        DECIMAL(12,2),
  35.         ProdNextShipDate DATE,
  36.  CONSTRAINT PKProduct PRIMARY KEY (ProdNo)  );
  37.  
  38. CREATE TABLE CR_Employee
  39. (   EmpNo       CHAR(8),
  40.     EmpFirstName    VARCHAR2(20) CONSTRAINT EmpFirstNameRequired NOT NULL,
  41.     EmpLastName     VARCHAR2(30) CONSTRAINT EmpLastNameRequired NOT NULL,
  42.     EmpPhone        CHAR(15),
  43.     EmpEMail        VARCHAR(50) CONSTRAINT EmpEMailRequired NOT NULL,
  44.     SupEmpNo    CHAR(8),
  45.         EmpCommRate DECIMAL(3,3),
  46. CONSTRAINT PKEmployee PRIMARY KEY (EmpNo),
  47. CONSTRAINT UniqueEMail UNIQUE(EmpEMail),
  48. CONSTRAINT FKSupEmpNo FOREIGN KEY (SupEmpNo) REFERENCES CR_Employee );
  49.  
  50. CREATE TABLE CR_OrderTbl
  51. (   OrdNo      CHAR(8),
  52.     OrdDate    DATE    CONSTRAINT OrdDateRequired NOT NULL,
  53.     CustNo     CHAR(8) CONSTRAINT CustNoRequired NOT NULL,
  54.         EmpNo      CHAR(8),
  55.         OrdName    VARCHAR2(50),
  56.         OrdStreet  VARCHAR2(50),
  57.         OrdCity    VARCHAR2(30),
  58.         OrdState   CHAR(2),
  59.         OrdZip     CHAR(10),
  60. CONSTRAINT PKOrderTbl PRIMARY KEY (OrdNo),
  61. CONSTRAINT FKCustNo FOREIGN KEY (CustNo) REFERENCES CR_Customer,
  62. CONSTRAINT FKEmpNo FOREIGN KEY (EmpNo) REFERENCES CR_Employee  );
  63.  
  64. CREATE TABLE CR_OrdLine
  65. (   OrdNo   CHAR(8),
  66.     ProdNo  CHAR(8),
  67.     Qty     INTEGER DEFAULT 1,
  68. CONSTRAINT PKOrdLine PRIMARY KEY (OrdNo, ProdNo),
  69. CONSTRAINT FKOrdNo FOREIGN KEY (OrdNo) REFERENCES CR_OrderTbl
  70.   ON DELETE CASCADE,
  71. CONSTRAINT FKProdNo FOREIGN KEY (ProdNo) REFERENCES CR_Product  );
  72.  
  73. INSERT INTO CR_customer
  74.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  75.     CustState, CustZip, CustBal)
  76.     VALUES('C0954327','Sheri','Gordon','336 Hill St.','Littleton','CO','80129-5543',230.00);
  77.  
  78.  
  79. INSERT INTO CR_customer
  80.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  81.     CustState, CustZip, CustBal)
  82.     VALUES('C1010398','Jim','Glussman','1432 E. Ravenna','Denver','CO','80111-0033',200.00);
  83.  
  84. INSERT INTO CR_customer
  85.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  86.     CustState, CustZip, CustBal)
  87.     VALUES('C2388597','Beth','Taylor','2396 Rafter Rd','Seattle','WA','98103-1121',500.00);
  88.  
  89. INSERT INTO CR_customer
  90.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  91.     CustState, CustZip, CustBal)
  92.     VALUES('C3340959','Betty','Wise','4334 153rd NW','Seattle','WA','98178-3311',200.00);
  93.  
  94. INSERT INTO CR_customer
  95.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  96.     CustState, CustZip, CustBal)
  97.     VALUES('C3499503','Bob','Mann','1190 Lorraine Cir.','Monroe','WA','98013-1095',0.00);
  98.  
  99. INSERT INTO CR_customer
  100.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  101.     CustState, CustZip, CustBal)
  102.     VALUES('C8543321','Ron','Thompson','789 122nd St.','Renton','WA','98666-1289',85.00);
  103.  
  104. INSERT INTO CR_customer
  105.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  106.     CustState, CustZip, CustBal)
  107.     VALUES('C8574932','Wally','Jones','411 Webber Ave.','Seattle','WA','98105-1093',1500.00);
  108.  
  109. INSERT INTO CR_customer
  110.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  111.     CustState, CustZip, CustBal)
  112.     VALUES('C8654390','Candy','Kendall','456 Pine St.','Seattle','WA','98105-3345',50.00);
  113.  
  114. INSERT INTO CR_customer
  115.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  116.     CustState, CustZip, CustBal)
  117.     VALUES('C9128574','Jerry','Wyatt','16212 123rd Ct.','Denver','CO','80222-0022',100.00);
  118.  
  119. INSERT INTO CR_customer
  120.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  121.     CustState, CustZip, CustBal)
  122.     VALUES('C9403348','Mike','Boren','642 Crest Ave.','Englewood','CO','80113-5431',0.00);
  123.  
  124. INSERT INTO CR_customer
  125.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  126.     CustState, CustZip, CustBal)
  127.     VALUES('C9432910','Larry','Styles','9825 S. Crest Lane','Bellevue','WA','98104-2211',250.00);
  128.  
  129. INSERT INTO CR_customer
  130.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  131.     CustState, CustZip, CustBal)
  132.     VALUES('C9543029','Sharon','Johnson','1223 Meyer Way','Fife','WA','98222-1123',856.00);
  133.  
  134. INSERT INTO CR_customer
  135.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  136.     CustState, CustZip, CustBal)
  137.     VALUES('C9549302','Todd','Hayes','1400 NW 88th','Lynnwood','WA','98036-2244',0.00);
  138.  
  139. INSERT INTO CR_customer
  140.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  141.     CustState, CustZip, CustBal)
  142.     VALUES('C9857432','Homer','Wells','123 Main St.','Seattle','WA','98105-4322',500.00);
  143.  
  144. INSERT INTO CR_customer
  145.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  146.     CustState, CustZip, CustBal)
  147.     VALUES('C9865874','Mary','Hill','206 McCaffrey','Littleton','CO','80129-5543',150.00);
  148.  
  149. INSERT INTO CR_customer
  150.     (CustNo, CustFirstName, CustLastName, CustStreet, CustCity,
  151.     CustState, CustZip, CustBal)
  152.     VALUES('C9943201','Harry','Sanders','1280 S. Hill Rd.','Fife','WA','98222-2258',1000.00);
  153.  
  154. INSERT INTO CR_Product
  155.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  156.     VALUES ('P0036566','17 inch Color Monitor','ColorMeg, Inc.',12,'20-Feb-2007',169.00);
  157.  
  158. INSERT INTO CR_Product
  159.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  160.     VALUES ('P0036577','19 inch Color Monitor','ColorMeg, Inc.',10,'20-Feb-2007',319.00);
  161.  
  162. INSERT INTO CR_Product
  163.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  164.     VALUES ('P1114590','R3000 Color Laser Printer','Connex',5,'22-Jan-2007',699.00);
  165.  
  166. INSERT INTO CR_Product
  167.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  168.     VALUES ('P1412138','10 Foot Printer Cable','Ethlite',100,'',12.00);
  169.  
  170. INSERT INTO CR_Product
  171.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  172.     VALUES ('P1445671','8-Outlet Surge Protector','Intersafe',33,'',14.99);
  173.  
  174. INSERT INTO CR_Product
  175.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  176.     VALUES ('P1556678','CVP Ink Jet Color Printer','Connex',8, '22-Jan-2007',99.00);
  177.  
  178. INSERT INTO CR_Product
  179.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  180.     VALUES ('P3455443','Color Ink Jet Cartridge','Connex',24,'22-Jan-2007',38.00);
  181.  
  182. INSERT INTO CR_Product
  183.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  184.     VALUES ('P4200344','36-Bit Color Scanner','UV Components',16,'29-Jan-2007',199.99);
  185.  
  186. INSERT INTO CR_Product
  187.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  188.     VALUES ('P6677900','Black Ink Jet Cartridge','Connex',44,'',25.69);
  189.  
  190. INSERT INTO CR_Product
  191.     (ProdNo, ProdName, ProdMfg, ProdQOH, ProdNextShipDate, ProdPrice)
  192.     VALUES ('P9995676','Battery Back-up System','Cybercx',12,'1-Feb-2007',89.00);
  193.  
  194. INSERT INTO CR_Employee
  195.     (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,
  196.     SupEmpNo, EmpCommRate)
  197.     VALUES ('E9884325','Thomas','Johnson','(303) 556-9987','TJohnson@bigco.com','',0.05);
  198.  
  199. INSERT INTO CR_Employee
  200.     (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,
  201.     SupEmpNo, EmpCommRate)
  202.     VALUES ('E8843211','Amy','Tang','(303) 556-4321','ATang@bigco.com','E9884325',0.04);
  203.  
  204. INSERT INTO CR_Employee
  205.     (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,
  206.     SupEmpNo, EmpCommRate)
  207.     VALUES ('E9345771','Colin','White','(303) 221-4453','CWhite@bigco.com','E9884325',0.04);
  208.  
  209. INSERT INTO CR_Employee
  210.     (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,
  211.     SupEmpNo, EmpCommRate)
  212.     VALUES ('E1329594','Landi','Santos','(303) 789-1234','LSantos@bigco.com','E8843211',0.02);
  213.  
  214. INSERT INTO CR_Employee
  215.     (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,
  216.     SupEmpNo, EmpCommRate)
  217.     VALUES ('E8544399','Joe','Jenkins','(303) 221-9875','JJenkins@bigco.com','E8843211',0.02);
  218.  
  219.  
  220. INSERT INTO CR_Employee
  221.     (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,
  222.     SupEmpNo, EmpCommRate)
  223.     VALUES ('E9954302','Mary','Hill','(303) 556-9871','MHill@bigco.com','E8843211',0.02);
  224.  
  225. INSERT INTO CR_Employee
  226.     (EmpNo, EmpFirstName, EmpLastName, EmpPhone, EmpEMail,
  227.     SupEmpNo)
  228.     VALUES ('E9973110','Theresa','Beck','(720) 320-2234','TBeck@bigco.com','E9884325');
  229.  
  230. INSERT INTO CR_OrderTbl
  231.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  232.     OrdState, OrdZip)
  233.     VALUES ('O1116324','23-Jan-2007','C0954327','E8544399','Sheri Gordon','336 Hill St.','Littleton','CO','80129-5543');
  234.  
  235. INSERT INTO CR_OrderTbl
  236.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  237.     OrdState, OrdZip)
  238.     VALUES ('O1231231','23-Jan-2007','C9432910','E9954302','Larry Styles','9825 S. Crest Lane','Bellevue','WA','98104-2211');
  239.  
  240. INSERT INTO CR_OrderTbl
  241.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  242.     OrdState, OrdZip)
  243.     VALUES ('O1241518','10-Feb-2007','C9549302','','Todd Hayes','1400 NW 88th','Lynnwood','WA','98036-2244');
  244.  
  245. INSERT INTO CR_OrderTbl
  246.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  247.     OrdState, OrdZip)
  248.     VALUES ('O1455122','9-Jan-2007','C8574932','E9345771','Wally Jones','411 Webber Ave.','Seattle','WA','98105-1093');
  249.  
  250. INSERT INTO CR_OrderTbl
  251.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  252.     OrdState, OrdZip)
  253.     VALUES ('O1579999','5-Jan-2007','C9543029','E8544399','Tom Johnson','1632 Ocean Dr.','Des Moines','WA','98222-1123');
  254.  
  255. INSERT INTO CR_OrderTbl
  256.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  257.     OrdState, OrdZip)
  258.     VALUES ('O1615141','23-Jan-2007','C8654390','E8544399','Candy Kendall','456 Pine St.','Seattle','WA','98105-3345');
  259.  
  260. INSERT INTO CR_OrderTbl
  261.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  262.     OrdState, OrdZip)
  263.     VALUES ('O1656777','11-Feb-2007','C8543321','','Ron Thompson','789 122nd St.','Renton','WA','98666-1289');
  264.  
  265. INSERT INTO CR_OrderTbl
  266.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  267.     OrdState, OrdZip)
  268.     VALUES ('O2233457','12-Jan-2007','C2388597','E9884325','Beth Taylor','2396 Rafter Rd','Seattle','WA','98103-1121');
  269.  
  270. INSERT INTO CR_OrderTbl
  271.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  272.     OrdState, OrdZip)
  273.     VALUES ('O2334661','14-Jan-2007','C0954327','E1329594','Mrs. Ruth Gordon','233 S. 166th','Seattle','WA','98011');
  274.  
  275. INSERT INTO CR_OrderTbl
  276.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  277.     OrdState, OrdZip)
  278.     VALUES ('O3252629','23-Jan-2007','C9403348','E9954302','Mike Boren','642 Crest Ave.','Englewood','CO','80113-5431');
  279.  
  280. INSERT INTO CR_OrderTbl
  281.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  282.     OrdState, OrdZip)
  283.     VALUES ('O3331222','13-Jan-2007','C1010398','','Jim Glussman','1432 E. Ravenna','Denver','CO','80111-0033');
  284.  
  285. INSERT INTO CR_OrderTbl
  286.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  287.     OrdState, OrdZip)
  288.     VALUES ('O3377543','15-Jan-2007','C9128574','E8843211','Jerry Wyatt','16212 123rd Ct.','Denver','CO','80222-0022');
  289.  
  290. INSERT INTO CR_OrderTbl
  291.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  292.     OrdState, OrdZip)
  293.     VALUES ('O4714645','11-Jan-2007','C2388597','E1329594','Beth Taylor','2396 Rafter Rd','Seattle','WA','98103-1121');
  294.  
  295. INSERT INTO CR_OrderTbl
  296.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  297.     OrdState, OrdZip)
  298.     VALUES ('O5511365','22-Jan-2007','C3340959','E9884325','Betty White','4334 153rd NW','Seattle','WA','98178-3311');
  299.  
  300. INSERT INTO CR_OrderTbl
  301.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  302.     OrdState, OrdZip)
  303.     VALUES ('O6565656','20-Jan-2007','C9865874','E8843211','Mr. Jack Sibley','166 E. 344th','Renton','WA','98006-5543');
  304.  
  305. INSERT INTO CR_OrderTbl
  306.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  307.     OrdState, OrdZip)
  308.     VALUES ('O7847172','23-Jan-2007','C9943201','','Harry Sanders','1280 S. Hill Rd.','Fife','WA','98222-2258');
  309.  
  310. INSERT INTO CR_OrderTbl
  311.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  312.     OrdState, OrdZip)
  313.     VALUES ('O7959898','19-Feb-2007','C8543321','E8544399','Ron Thompson','789 122nd St.','Renton','WA','98666-1289');
  314.  
  315. INSERT INTO CR_OrderTbl
  316.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  317.     OrdState, OrdZip)
  318.     VALUES ('O7989497','16-Jan-2007','C3499503','E9345771','Bob Mann','1190 Lorraine Cir.','Monroe','WA','98013-1095');
  319.  
  320. INSERT INTO CR_OrderTbl
  321.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  322.     OrdState, OrdZip)
  323.     VALUES ('O8979495','23-Jan-2007','C9865874','','HelenSibley','206 McCaffrey','Renton','WA','98006-5543');
  324.  
  325. INSERT INTO CR_OrderTbl
  326.     (OrdNo, OrdDate, CustNo, EmpNo, OrdName, OrdStreet, OrdCity,
  327.     OrdState, OrdZip)
  328.     VALUES ('O9919699','11-Feb-2007','C9857432','E9954302','Homer Wells','123 Main St.','Seattle','WA','98105-4322');
  329.  
  330. INSERT INTO CR_ordline
  331.     (OrdNo, ProdNo, Qty)
  332.     VALUES('O1116324','P1445671',1);
  333.  
  334. INSERT INTO CR_ordline
  335.     (OrdNo, ProdNo, Qty)
  336.     VALUES('O1231231','P0036566',1);
  337.  
  338. INSERT INTO CR_ordline
  339.     (OrdNo, ProdNo, Qty)
  340.     VALUES('O1231231','P1445671',1);
  341.  
  342. INSERT INTO CR_ordline
  343.     (OrdNo, ProdNo, Qty)
  344.     VALUES('O1241518','P0036577',1);
  345.  
  346. INSERT INTO CR_ordline
  347.     (OrdNo, ProdNo, Qty)
  348.     VALUES('O1455122','P4200344',1);
  349.  
  350.  
  351. INSERT INTO CR_ordline
  352.     (OrdNo, ProdNo, Qty)
  353.     VALUES('O1579999','P1556678',1);
  354.  
  355. INSERT INTO CR_ordline
  356.     (OrdNo, ProdNo, Qty)
  357.     VALUES('O1579999','P6677900',1);
  358.  
  359. INSERT INTO CR_ordline
  360.     (OrdNo, ProdNo, Qty)
  361.     VALUES('O1579999','P9995676',1);
  362.  
  363. INSERT INTO CR_ordline
  364.     (OrdNo, ProdNo, Qty)
  365.     VALUES('O1615141','P0036566',1);
  366.  
  367. INSERT INTO CR_ordline
  368.     (OrdNo, ProdNo, Qty)
  369.     VALUES('O1615141','P1445671',1);
  370.  
  371. INSERT INTO CR_ordline
  372.     (OrdNo, ProdNo, Qty)
  373.     VALUES('O1615141','P4200344',1);
  374.  
  375. INSERT INTO CR_ordline
  376.     (OrdNo, ProdNo, Qty)
  377.     VALUES('O1656777','P1445671',1);
  378.  
  379. INSERT INTO CR_ordline
  380.     (OrdNo, ProdNo, Qty)
  381.     VALUES('O1656777','P1556678',1);
  382.  
  383. INSERT INTO CR_ordline
  384.     (OrdNo, ProdNo, Qty)
  385.     VALUES('O2233457','P0036577',1);
  386.  
  387. INSERT INTO CR_ordline
  388.     (OrdNo, ProdNo, Qty)
  389.     VALUES('O2233457','P1445671',1);
  390.  
  391. INSERT INTO CR_ordline
  392.     (OrdNo, ProdNo, Qty)
  393.     VALUES('O2334661','P0036566',1);
  394.  
  395. INSERT INTO CR_ordline
  396.     (OrdNo, ProdNo, Qty)
  397.     VALUES('O2334661','P1412138',1);
  398.  
  399. INSERT INTO CR_ordline
  400.     (OrdNo, ProdNo, Qty)
  401.     VALUES('O2334661','P1556678',1);
  402.  
  403. INSERT INTO CR_ordline
  404.     (OrdNo, ProdNo, Qty)
  405.     VALUES('O3252629','P4200344',1);
  406.  
  407. INSERT INTO CR_ordline
  408.     (OrdNo, ProdNo, Qty)
  409.     VALUES('O3252629','P9995676',1);
  410.  
  411. INSERT INTO CR_ordline
  412.     (OrdNo, ProdNo, Qty)
  413.     VALUES('O3331222','P1412138',1);
  414.  
  415. INSERT INTO CR_ordline
  416.     (OrdNo, ProdNo, Qty)
  417.     VALUES('O3331222','P1556678',1);
  418.  
  419. INSERT INTO CR_ordline
  420.     (OrdNo, ProdNo, Qty)
  421.     VALUES('O3331222','P3455443',1);
  422.  
  423. INSERT INTO CR_ordline
  424.     (OrdNo, ProdNo, Qty)
  425.     VALUES('O3377543','P1445671',1);
  426.  
  427. INSERT INTO CR_ordline
  428.     (OrdNo, ProdNo, Qty)
  429.     VALUES('O3377543','P9995676',1);
  430.  
  431. INSERT INTO CR_ordline
  432.     (OrdNo, ProdNo, Qty)
  433.     VALUES('O4714645','P0036566',1);
  434.  
  435. INSERT INTO CR_ordline
  436.     (OrdNo, ProdNo, Qty)
  437.     VALUES('O4714645','P9995676',1);
  438.  
  439. INSERT INTO CR_ordline
  440.     (OrdNo, ProdNo, Qty)
  441.     VALUES('O5511365','P1412138',1);
  442.  
  443. INSERT INTO CR_ordline
  444.     (OrdNo, ProdNo, Qty)
  445.     VALUES('O5511365','P1445671',1);
  446.  
  447. INSERT INTO CR_ordline
  448.     (OrdNo, ProdNo, Qty)
  449.     VALUES('O5511365','P1556678',1);
  450.  
  451. INSERT INTO CR_ordline
  452.     (OrdNo, ProdNo, Qty)
  453.     VALUES('O5511365','P3455443',1);
  454.  
  455. INSERT INTO CR_ordline
  456.     (OrdNo, ProdNo, Qty)
  457.     VALUES('O5511365','P6677900',1);
  458.  
  459. INSERT INTO CR_ordline
  460.     (OrdNo, ProdNo, Qty)
  461.     VALUES('O6565656','P0036566',10);
  462.  
  463. INSERT INTO CR_ordline
  464.     (OrdNo, ProdNo, Qty)
  465.     VALUES('O7847172','P1556678',1);
  466.  
  467. INSERT INTO CR_ordline
  468.     (OrdNo, ProdNo, Qty)
  469.     VALUES('O7847172','P6677900',1);
  470.  
  471. INSERT INTO CR_ordline
  472.     (OrdNo, ProdNo, Qty)
  473.     VALUES('O7959898','P1412138',5);
  474.  
  475. INSERT INTO CR_ordline
  476.     (OrdNo, ProdNo, Qty)
  477.     VALUES('O7959898','P1556678',5);
  478.  
  479. INSERT INTO CR_ordline
  480.     (OrdNo, ProdNo, Qty)
  481.     VALUES('O7959898','P3455443',5);
  482.  
  483. INSERT INTO CR_ordline
  484.     (OrdNo, ProdNo, Qty)
  485.     VALUES('O7959898','P6677900',5);
  486.  
  487. INSERT INTO CR_ordline
  488.     (OrdNo, ProdNo, Qty)
  489.     VALUES('O7989497','P1114590',2);
  490.  
  491. INSERT INTO CR_ordline
  492.     (OrdNo, ProdNo, Qty)
  493.     VALUES('O7989497','P1412138',2);
  494.  
  495. INSERT INTO CR_ordline
  496.     (OrdNo, ProdNo, Qty)
  497.     VALUES('O7989497','P1445671',3);
  498.  
  499. INSERT INTO CR_ordline
  500.     (OrdNo, ProdNo, Qty)
  501.     VALUES('O8979495','P1114590',1);
  502.  
  503. INSERT INTO CR_ordline
  504.     (OrdNo, ProdNo, Qty)
  505.     VALUES('O8979495','P1412138',1);
  506.  
  507. INSERT INTO CR_ordline
  508.     (OrdNo, ProdNo, Qty)
  509.     VALUES('O8979495','P1445671',1);
  510.  
  511. INSERT INTO CR_ordline
  512.     (OrdNo, ProdNo, Qty)
  513.     VALUES('O9919699','P0036577',1);
  514.  
  515. INSERT INTO CR_ordline
  516.     (OrdNo, ProdNo, Qty)
  517.     VALUES('O9919699','P1114590',1);
  518.  
  519. INSERT INTO CR_ordline
  520.     (OrdNo, ProdNo, Qty)
  521.     VALUES('O9919699','P4200344',1);
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!