spool c:\create_tables.log

drop user iself cascade;

CREATE TABLESPACE ISELF_DATA
DATAFILE 'C:\ISELF_DATA.DBF' SIZE 50M;

CREATE USER ISELF IDENTIFIED BY SCHOOLING DEFAULT TABLESPACE ISELF_DATA;

GRANT RESOURCE, CONNECT TO ISELF;

CREATE TABLE ISELF."CUSTOMER" ("CUSTID" NUMBER(6, 0) primary key, "NAME" VARCHAR2(45), "ADDRESS" VARCHAR2(40), "CITY" VARCHAR2(30), "STATE" VARCHAR2(2), "ZIP" VARCHAR2(9), "AREA" NUMBER(3, 0), "PHONE" VARCHAR2(9), "REPID" NUMBER(4, 0) NOT NULL ENABLE, "CREDITLIMIT" NUMBER(9, 2), "COMMENTS" LONG) ;

CREATE TABLE ISELF."CUSTOMERS" ("ID" NUMBER primary key, "FIRST_NAME" VARCHAR2(20) NOT NULL ENABLE, "LAST_NAME" VARCHAR2(20) NOT NULL ENABLE, "ADDRESS_LINE_1" VARCHAR2(30), "ADDRESS_LINE_2" VARCHAR2(30), "ADDRESS_LINE_3" VARCHAR2(30), "PHONE_NUMBER" VARCHAR2(15), "FAX_NUMBER" VARCHAR2(15) NOT NULL ENABLE, "COMM_PAID_YTD" NUMBER(9, 2) NOT NULL ENABLE, "ACCOUNT_BALANCE" NUMBER(9, 2) NOT NULL ENABLE, "COMMENTS" VARCHAR2(240))  ;

CREATE TABLE ISELF."DEPT" ("DEPTNO" NUMBER(2, 0) primary key, "DNAME" VARCHAR2(14), "LOC" VARCHAR2(13)) ;

CREATE TABLE ISELF."EMP" ("EMPNO" NUMBER(4, 0) primary key, "ENAME" VARCHAR2(10), "JOB" VARCHAR2(9), "MGR" NUMBER(4, 0), "HIREDATE" DATE, "SAL" NUMBER(7, 2), "COMM" NUMBER(7, 2), "DEPTNO" NUMBER(2, 0)) ;

CREATE TABLE ISELF."ITEM" ("ORDID" NUMBER(4, 0), "ITEMID" NUMBER(4, 0), "PRODID" NUMBER(6, 0), "ACTUALPRICE" NUMBER(8, 2), "QTY" NUMBER(8, 0), "ITEMTOT" NUMBER(8, 2)) ;
alter table iself.item add constraint pk_item_01 primary key (ordid,itemid);
CREATE TABLE ISELF."ORD" ("ORDID" NUMBER(4, 0) primary key, "ORDERDATE" DATE, "COMMPLAN" VARCHAR2(1), "CUSTID" NUMBER(6, 0) NOT NULL ENABLE, "SHIPDATE" DATE, "TOTAL" NUMBER(8, 2))  ;

CREATE TABLE ISELF."PORTFOLIO" ("CUSTOMER_ID" NUMBER NOT NULL ENABLE, "STOCK_SYMBOL" VARCHAR2(10) NOT NULL ENABLE, "SHARES_OWNED" NUMBER NOT NULL ENABLE)  ;
alter table iself.portfolio add constraint pk_portfolio_01 primary key (customer_id, stock_symbol);
CREATE TABLE ISELF."PRICE" ("PRODID" NUMBER(6, 0) NOT NULL ENABLE, "STDPRICE" NUMBER(8, 2), "MINPRICE" NUMBER(8, 2), "STARTDATE" DATE, "ENDDATE" DATE)  ;

CREATE TABLE ISELF."PRODUCT" ("PRODID" NUMBER(6, 0) primary key, "DESCRIP" VARCHAR2(30)) ;

CREATE TABLE ISELF."STOCKS" ("SYMBOL" VARCHAR2(10), "COMPANY" VARCHAR2(20) NOT NULL ENABLE, "CURRENT_PRICE" NUMBER(7, 3) NOT NULL ENABLE, "TRADE_DATE" DATE, "NUMBER_TRADED_TODAY" NUMBER, "TODAYS_HIGH" NUMBER, "TODAYS_LOW" NUMBER) ;

CREATE TABLE ISELF."STOCK_HISTORY" ("SYMBOL" VARCHAR2(12) primary key, "SALES" NUMBER, "HIGH_365" NUMBER, "LOW_365" NUMBER, "DIV" NUMBER, "P_E" NUMBER, "YIELD" NUMBER) ;

---------------------------------------------------------------

insert into iself.dept values ('10','ACCOUNTING','NEW YORK');  
insert into iself.dept values ('20','RESEARCH','DALLAS');
insert into iself.dept values ('30','SALES','CHICAGO');

insert into iself.emp values ('7369','SMITH','CLERK','7902','17-DEC-80','1050','','20');
insert into iself.emp values ('7499','ALLEN','SALESMAN','7698','20-FEB-81','3758.57','300','30');
insert into iself.emp values ('7521','WARD','SALESMAN','7698','22-FEB-81','2415.77','500','30'); 
insert into iself.emp values ('7566','JONES','MANAGER','7839','02-APR-81','3123.75','','20'); 
insert into iself.emp values ('7654','MARTIN','SALESMAN','7698','28-SEP-81','2536.56','1400','30'); 
insert into iself.emp values ('7698','BLAKE','MANAGER','7839','01-MAY-81','3464.2','','30');  
insert into iself.emp values ('7782','CLARK','MANAGER','7839','09-JUN-81','2572.5','','10');  
insert into iself.emp values ('7788','SCOTT','ANALYST','7566','19-APR-87','3150','','20'); 
insert into iself.emp values ('7839','KING','PRESIDENT','','17-NOV-81','5250','','10'); 
insert into iself.emp values ('7844','TURNER','SALESMAN','7698','08-SEP-81','2898.92','0','30'); 
insert into iself.emp values ('7876','ADAMS','CLERK','7788','23-MAY-87','1337.06','','20');
insert into iself.emp values ('7900','JAMES','CLERK','7698','03-DEC-81','997.5','','30');  
insert into iself.emp values ('7902','FORD','ANALYST','7566','03-DEC-81','3150','','20');  
insert into iself.emp values ('7934','MILLER','CLERK','7782','23-JAN-82','1365','','10');  

insert into iself.customer values ('100','EVERY MOUNTAIN','345 VIEWRIDGE','BELMONT','CA','96711','415','598-6609','7844','5000',''); 
insert into iself.customer values ('101','TKB SPORT SHOP','490 BOLI RD.','REDWOOD CITY','CA','94061','415','368-1223','7521','10000','');  
insert into iself.customer values ('102','VOLLYRITE','9722 HAMILTON','BURLINGAME','CA','95133','415','644-3341','7654','7000','');
insert into iself.customer values ('103','JUST TENNIS','HILLVIEW MALL','BURLINGAME','CA','97544','415','677-9312','7521','3000',''); 
insert into iself.customer values ('104','EVERY MOUNTAIN','574 SURRY RD.','CUPERTINO','CA','93301','408','996-2323','7499','10000',''); 
insert into iself.customer values ('105','K + T SPORTS','3476 EL PASEO','SANTA CLARA','CA','91003','408','376-9966','7844','5000','');  
insert into iself.customer values ('106','SHAPE UP','908 SEQUOIA','PALO ALTO','CA','94301','415','364-9777','7521','6000',''); 
insert into iself.customer values ('107','WOMENS SPORTS','VALCO VILLAGE','SUNNYVALE','CA','93301','408','967-4398','7499','10000','');  
insert into iself.customer values ('108','NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER','98 LONE PINE WAY','HIBBING','MN','55649','612','566-9123','7844','8000',''); 

insert into iself.ord values ('610','07-JAN-87','A','101','08-JAN-87','101.4');
insert into iself.ord values ('611','11-JAN-87','C','102','11-JAN-87','45');
insert into iself.ord values ('612','15-JAN-87','C','104','20-JAN-87','5860'); 
insert into iself.ord values ('601','01-MAY-86','A','106','30-MAY-86','2.4');  
insert into iself.ord values ('602','05-JUN-86','C','102','20-JUN-86','56');
insert into iself.ord values ('604','15-JUN-86','A','106','30-JUN-86','698');  
insert into iself.ord values ('605','14-JUL-86','A','106','30-JUL-86','8324'); 
insert into iself.ord values ('606','14-JUL-86','A','100','30-JUL-86','3.4');  
insert into iself.ord values ('609','01-AUG-86','A','100','15-AUG-86','97.5'); 
insert into iself.ord values ('607','18-JUL-86','B','104','18-JUL-86','5.6');  
insert into iself.ord values ('608','25-JUL-86','C','104','25-JUL-86','35.2'); 
insert into iself.ord values ('603','05-JUN-86','','102','05-JUN-86','224');
insert into iself.ord values ('620','12-MAR-87','','100','12-MAR-87','4450');  
insert into iself.ord values ('613','01-FEB-87','','108','01-FEB-87','6400');  
insert into iself.ord values ('614','01-FEB-87','','102','05-FEB-87','23940'); 
insert into iself.ord values ('616','03-FEB-87','','103','10-FEB-87','764');
insert into iself.ord values ('619','22-FEB-87','','104','04-FEB-87','1260');  
insert into iself.ord values ('617','05-FEB-87','','105','03-MAR-87','46370'); 
insert into iself.ord values ('615','01-FEB-87','','107','06-FEB-87','710');
insert into iself.ord values ('618','15-FEB-87','A','102','06-MAR-87','3510.5');  
insert into iself.ord values ('621','15-MAR-87','A','100','01-JAN-87','730');  

insert into iself.item values ('610','3','100890','58','1','58');  
insert into iself.item values ('611','1','100861','45','1','45');  
insert into iself.item values ('612','1','100860','30','100','3000'); 
insert into iself.item values ('601','1','200376','2.4','1','2.4');
insert into iself.item values ('602','1','100870','2.8','20','56');
insert into iself.item values ('604','1','100890','58','3','174'); 
insert into iself.item values ('604','2','100861','42','2','84');  
insert into iself.item values ('604','3','100860','44','10','440');
insert into iself.item values ('603','2','100860','56','4','224'); 
insert into iself.item values ('610','1','100860','35','1','35');  
insert into iself.item values ('610','2','100870','2.8','3','8.4');
insert into iself.item values ('613','4','200376','2.2','200','440'); 
insert into iself.item values ('614','1','100860','35','444','15540');
insert into iself.item values ('614','2','100870','2.8','1000','2800');  
insert into iself.item values ('612','2','100861','40.5','20','810'); 
insert into iself.item values ('612','3','101863','10','150','1500'); 
insert into iself.item values ('620','1','100860','35','10','350');
insert into iself.item values ('620','2','200376','2.4','1000','2400');  
insert into iself.item values ('620','3','102130','3.4','500','1700');
insert into iself.item values ('613','1','100871','5.6','100','560'); 
insert into iself.item values ('613','2','101860','24','200','4800'); 
insert into iself.item values ('613','3','200380','4','150','600');
insert into iself.item values ('619','3','102130','3.4','100','340'); 
insert into iself.item values ('617','1','100860','35','50','1750');  
insert into iself.item values ('617','2','100861','45','100','4500'); 
insert into iself.item values ('614','3','100871','5.6','1000','5600');  
insert into iself.item values ('616','1','100861','45','10','450');
insert into iself.item values ('616','2','100870','2.8','50','140');  
insert into iself.item values ('616','3','100890','58','2','116'); 
insert into iself.item values ('616','4','102130','3.4','10','34');
insert into iself.item values ('616','5','200376','2.4','10','24');
insert into iself.item values ('619','1','200380','4','100','400');
insert into iself.item values ('619','2','200376','2.4','100','240'); 
insert into iself.item values ('615','1','100861','45','4','180'); 
insert into iself.item values ('607','1','100871','5.6','1','5.6');
insert into iself.item values ('615','2','100870','2.8','100','280'); 
insert into iself.item values ('617','3','100870','2.8','500','1400');
insert into iself.item values ('617','4','100871','5.6','500','2800');
insert into iself.item values ('617','5','100890','58','500','29000');
insert into iself.item values ('617','6','101860','24','100','2400'); 
insert into iself.item values ('617','7','101863','12.5','200','2500');  
insert into iself.item values ('617','8','102130','3.4','100','340'); 
insert into iself.item values ('617','9','200376','2.4','200','480'); 
insert into iself.item values ('617','10','200380','4','300','1200'); 
insert into iself.item values ('609','2','100870','2.5','5','12.5');  
insert into iself.item values ('609','3','100890','50','1','50');  
insert into iself.item values ('618','1','100860','35','23','805');
insert into iself.item values ('618','2','100861','45.11','50','2255.5');
insert into iself.item values ('618','3','100870','45','10','450');
insert into iself.item values ('621','1','100861','45','10','450');
insert into iself.item values ('621','2','100870','2.8','100','280'); 
insert into iself.item values ('615','3','100871','5','50','250'); 
insert into iself.item values ('608','1','101860','24','1','24');  
insert into iself.item values ('608','2','100871','5.6','2','11.2');  
insert into iself.item values ('609','1','100861','35','1','35');  
insert into iself.item values ('606','1','102130','3.4','1','3.4');
insert into iself.item values ('605','1','100861','45','100','4500'); 
insert into iself.item values ('605','2','100870','2.8','500','1400');
insert into iself.item values ('605','3','100890','58','5','290'); 
insert into iself.item values ('605','4','101860','24','50','1200');  
insert into iself.item values ('605','5','101863','9','100','900');
insert into iself.item values ('605','6','102130','3.4','10','34');
insert into iself.item values ('612','4','100871','5.5','100','550'); 
insert into iself.item values ('619','4','100871','5.6','50','280');  

insert into iself.price values ('100871','4.8','3.2','01-JAN-85','01-DEC-85'); 
insert into iself.price values ('100890','58','46.4','01-JAN-85',''); 
insert into iself.price values ('100890','54','40.5','01-JUN-84','31-MAY-84'); 
insert into iself.price values ('100860','35','28','01-JUN-86','');
insert into iself.price values ('100860','32','25.6','01-JAN-86','31-MAY-86'); 
insert into iself.price values ('100860','30','24','01-JAN-85','31-DEC-85');
insert into iself.price values ('100861','45','36','01-JUN-86','');
insert into iself.price values ('100861','42','33.6','01-JAN-86','31-MAY-86'); 
insert into iself.price values ('100861','39','31.2','01-JAN-85','31-DEC-85'); 
insert into iself.price values ('100870','2.8','2.4','01-JAN-86',''); 
insert into iself.price values ('100870','2.4','1.9','01-JAN-85','01-DEC-85'); 
insert into iself.price values ('100871','5.6','4.8','01-JAN-86',''); 
insert into iself.price values ('101860','24','18','15-FEB-85','');
insert into iself.price values ('101863','12.5','9.4','15-FEB-85','');
insert into iself.price values ('102130','3.4','2.8','18-AUG-85',''); 
insert into iself.price values ('200376','2.4','1.75','15-NOV-86','');
insert into iself.price values ('200380','4','3.2','15-NOV-86','');

insert into iself.product values ('100860','ACE TENNIS RACKET I'); 
insert into iself.product values ('100861','ACE TENNIS RACKET II');
insert into iself.product values ('100870','ACE TENNIS BALLS-3 PACK');
insert into iself.product values ('100871','ACE TENNIS BALLS-6 PACK');
insert into iself.product values ('100890','ACE TENNIS NET');
insert into iself.product values ('101860','SP TENNIS RACKET'); 
insert into iself.product values ('101863','SP JUNIOR RACKET'); 
insert into iself.product values ('102130','RH GUIDE TO TENNIS');  
insert into iself.product values ('200376','SB ENERGY BAR-6 PACK');
insert into iself.product values ('200380','SB VITA SNACK-6 PACK');

insert into iself.customers values ('50','Natarajan','Iyer','9994 Foster Street','Foster City, CA 90003','','415-506-5001','415-506-3999','0','90000','T');  
insert into iself.customers values ('20','Mike','Kanaley','9989 Cross Street','Bealville, CA 90006','','415-506-5002','415-506-3998','0','80000','the quick brown fox'); 
insert into iself.customers values ('30','Holway','Kalikow','9984 Eye Street','Caliente, CA 90009','','415-506-5003','415-506-3997','0','70000','Lets see how Mr. Holway Kalikow does this year since last year he did not get any commission though balance maintained high.'); 
insert into iself.customers values ('40','Earl','Blair','9979 Colson Blvd.','Mojave, CA 90012','','415-506-5004','415-506-3996','0','60000','This is to test system editor at work. Wondering where it would wrap automatically even though I am not typing any carriage return.');  
insert into iself.customers values ('60','Charles','Weiss','869 Ulloa Street','Redwood City, CA 90018','','415-506-5006','415-506-3994','0','40000','');  
insert into iself.customers values ('70','Vincent','Morello','9964 Santa Fe Avenue','Albany, CA 90021','','415-506-5007','415-506-3993','0','30000','');  
insert into iself.customers values ('90','Clifford','Godwin','9884 Sixth Street','Berkeley, CA 90069','','415-506-5023','415-506-3977','0','70000','THIS IS MYEDITOR TO TEST');
insert into iself.customers values ('100','Jagdish','Pamnani','9879 Detail Way','San Luis Obispo, CA 98072','','415-506-5024','415-506-3976','0','60000','');
insert into iself.customers values ('110','Leonard','Towle','23 Western Avenue','Moapa, NV 89943','','415-506-5025','415-506-3975','0','50000',''); 
insert into iself.customers values ('120','Ben','King','8320 Helper Blvd.','Bakersfield, CA 90078','','415-506-5026','415-506-3974','0','40000','THIS IS MYEDTOR');
insert into iself.customers values ('130','Maryam','Saffari','9864 Milwaukee Ave.','Minot, SD 65601','','415-506-5027','415-506-3973','0','30000',''); 
insert into iself.customers values ('140','Arturo','Zacarias','9859 Picasso Street','Havre, MT 66184','','415-506-5028','415-506-3972','0','20000','');
insert into iself.customers values ('80','Tim','Jones','2380 Sunset Boulevard','San Francisco, CA 94109','','415-898-5363','415-898-5334','23400','12300','Tim prefers to trade in NASDAQ stock.'); 

insert into iself.portfolio values ('10','CSCO','2037');  
insert into iself.portfolio values ('10','GUIG','111');
insert into iself.portfolio values ('20','DYTY','3937');  
insert into iself.portfolio values ('20','ULTM','961');
insert into iself.portfolio values ('20','VLVO','1203');  
insert into iself.portfolio values ('30','ALCB','2330');  
insert into iself.portfolio values ('30','VICA','989');
insert into iself.portfolio values ('30','GUIG','264');
insert into iself.portfolio values ('40','DYTY','2295');  
insert into iself.portfolio values ('40','ORCL','1533');  
insert into iself.portfolio values ('40','VLVO','3205');  
insert into iself.portfolio values ('50','WBTK','3674');  
insert into iself.portfolio values ('50','OJSP','4589');  
insert into iself.portfolio values ('50','VICA','573');
insert into iself.portfolio values ('60','VICA','786');
insert into iself.portfolio values ('60','CSCO','2037');  
insert into iself.portfolio values ('60','GUIG','111');
insert into iself.portfolio values ('70','DYTY','3937');  
insert into iself.portfolio values ('70','OJSP','2674');  
insert into iself.portfolio values ('70','VICA','333');
insert into iself.portfolio values ('80','ULTM','1458');  
insert into iself.portfolio values ('90','DYTY','2295');  
insert into iself.portfolio values ('90','GUIG','111');
insert into iself.portfolio values ('90','MSFT','2625');  
insert into iself.portfolio values ('100','MSFT','1722'); 
insert into iself.portfolio values ('100','CSCO','1834'); 
insert into iself.portfolio values ('100','ORCL','1970'); 
insert into iself.portfolio values ('110','MSFT','2359'); 
insert into iself.portfolio values ('110','WBTK','4076'); 
insert into iself.portfolio values ('110','ALCB','876');  
insert into iself.portfolio values ('120','MSFT','987');  
insert into iself.portfolio values ('120','ORCL','1148'); 
insert into iself.portfolio values ('120','CSCO','2301'); 
insert into iself.portfolio values ('130','ORCL','1573'); 
insert into iself.portfolio values ('130','GUIG','293');  
insert into iself.portfolio values ('130','VICA','989');  
insert into iself.portfolio values ('140','OJSP','4076'); 
insert into iself.portfolio values ('140','ULTM','961');  
insert into iself.portfolio values ('140','CSCO','769');  

insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.13','01-SEP-94','666','18.89','18.28');  
insert into iself.stocks values ('WBTK','Webbe Trucking','25.77','01-SEP-94','746','25.77','23.15');
insert into iself.stocks values ('DYTY','Dinosaur Toys','5.28','01-SEP-94','1500','5.83','5.39');
insert into iself.stocks values ('GUIG','GUI Intl.','25.32','01-SEP-94','203','28.4','24.61');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.35','01-SEP-94','290','14.5','14.38'); 
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.42','01-SEP-94','1341','11.45','11.27');  
insert into iself.stocks values ('ORCL','Oracle Corp.','49','01-SEP-94','1315','49.77','44.73'); 
insert into iself.stocks values ('VICA','Victoria Apparel','35.77','01-SEP-94','547','36.23','34.89'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','01-SEP-94','1672','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','28.55','01-SEP-94','916','29','27.14');
insert into iself.stocks values ('CSCO','Cisco Systems','20.5','01-SEP-94','1306','22.28','18.06'); 
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.25','31-AUG-94','4277','18.25','18.25'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','22.5','31-AUG-94','2893','22.5','22.5');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','5.45','31-AUG-94','100000','5.45','5.45'); 
insert into iself.stocks values ('GUIG','GUI Intl.','28.4','31-AUG-94','50218','28.4','28.4');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.5','31-AUG-94','1240','14.5','14.5');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.25','31-AUG-94','2388','11.25','11.25');  
insert into iself.stocks values ('ORCL','Oracle Corp.','47.25','31-AUG-94','95300','47.25','47.25');
insert into iself.stocks values ('VICA','Victoria Apparel','35','31-AUG-94','4500','35','35');
insert into iself.stocks values ('MSFT','Microsoft','27','31-AUG-94','2400','27','27'); 
insert into iself.stocks values ('VLVO','Volvo','29','31-AUG-94','8400','29','29');  
insert into iself.stocks values ('CSCO','Cisco Systems','17','31-AUG-94','24250','17','17');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.31','11-OCT-94','528','15.31','14.51');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','14.86','11-OCT-94','12174','12.92','11.56'); 
insert into iself.stocks values ('ORCL','Oracle Corp.','104.77','11-OCT-94','4338','106.91','56.16');  
insert into iself.stocks values ('VICA','Victoria Apparel','52.73','11-OCT-94','1486','52.73','38.19');
insert into iself.stocks values ('MSFT','Microsoft','34.02','11-OCT-94','56445','37.22','27.01');
insert into iself.stocks values ('VLVO','Volvo','38.68','11-OCT-94','858','39.47','29.24');
insert into iself.stocks values ('CSCO','Cisco Systems','44.01','11-OCT-94','3246','44.96','22.59');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','21.19','11-OCT-94','624','21.19','18.74');  
insert into iself.stocks values ('WBTK','Webbe Trucking','34.97','11-OCT-94','4255','36.41','25.28');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','9.71','11-OCT-94','2732','9.72','6.07');
insert into iself.stocks values ('GUIG','GUI Intl.','54.23','11-OCT-94','416','55.34','30');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.27','10-OCT-94','1879','15.31','14.51');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.8','10-OCT-94','3496','12.92','11.56');
insert into iself.stocks values ('ORCL','Oracle Corp.','102.79','10-OCT-94','3519','104.93','55.76');  
insert into iself.stocks values ('VICA','Victoria Apparel','51.18','10-OCT-94','1268','51.72','37.99');
insert into iself.stocks values ('MSFT','Microsoft','27.02','10-OCT-94','5558','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','38.7','10-OCT-94','810','38.73','29.09'); 
insert into iself.stocks values ('CSCO','Cisco Systems','44.94','10-OCT-94','2372','44.96','22.59');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','21.19','10-OCT-94','589','21.19','18.74');  
insert into iself.stocks values ('WBTK','Webbe Trucking','36.41','10-OCT-94','3225','36.41','25.28');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','8.97','10-OCT-94','4666','9.72','6.07');
insert into iself.stocks values ('GUIG','GUI Intl.','53.22','10-OCT-94','285','53.22','29.57');  
insert into iself.stocks values ('ALCB','Alaska Corned Beef','20.77','05-OCT-94','561','20.78','18.66');  
insert into iself.stocks values ('WBTK','Webbe Trucking','35.05','05-OCT-94','3071','35.05','25.01');  
insert into iself.stocks values ('ALCB','Alaska Corned Beef','20.77','06-OCT-94','595','20.78','18.66');  
insert into iself.stocks values ('WBTK','Webbe Trucking','33.66','06-OCT-94','4052','35.05','25.01');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','8.98','06-OCT-94','2602','8.99','5.93');
insert into iself.stocks values ('GUIG','GUI Intl.','49.33','06-OCT-94','394','50.34','29');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.19','06-OCT-94','502','15.19','14.49');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.68','06-OCT-94','2070','12.74','11.52');  
insert into iself.stocks values ('ORCL','Oracle Corp.','95.27','06-OCT-94','4131','97.21','54.22'); 
insert into iself.stocks values ('VICA','Victoria Apparel','50.25','06-OCT-94','1415','50.25','37.7'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','06-OCT-94','6136','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','37.24','06-OCT-94','818','38','28.94');
insert into iself.stocks values ('CSCO','Cisco Systems','40.02','06-OCT-94','3092','40.89','21.78');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','20.77','07-OCT-94','1156','20.98','18.7');  
insert into iself.stocks values ('WBTK','Webbe Trucking','35.02','07-OCT-94','1993','35.05','25.01');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','8.98','07-OCT-94','4294','9.16','5.96');
insert into iself.stocks values ('GUIG','GUI Intl.','48.3','07-OCT-94','299','50.34','29');
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.15','07-OCT-94','691','15.19','14.49');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.74','07-OCT-94','3797','12.74','11.52');  
insert into iself.stocks values ('ORCL','Oracle Corp.','97.09','07-OCT-94','2401','97.21','54.22'); 
insert into iself.stocks values ('VICA','Victoria Apparel','50.73','07-OCT-94','1318','50.75','37.8'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','07-OCT-94','3810','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','37.23','07-OCT-94','1590','38','28.94');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','8.3','03-OCT-94','6568','8.49','5.83'); 
insert into iself.stocks values ('GUIG','GUI Intl.','46.59','03-OCT-94','241','46.59','28.25');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.62','03-OCT-94','6292','12.62','11.5');
insert into iself.stocks values ('ORCL','Oracle Corp.','86.47','03-OCT-94','2209','90.07','52.79'); 
insert into iself.stocks values ('VICA','Victoria Apparel','47.83','03-OCT-94','1631','48.31','37.31');
insert into iself.stocks values ('MSFT','Microsoft','27.02','03-OCT-94','4779','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','37.28','03-OCT-94','2047','37.28','28.8');
insert into iself.stocks values ('CSCO','Cisco Systems','39.35','03-OCT-94','4346','40.17','21.63');
insert into iself.stocks values ('DYTY','Dinosaur Toys','8.99','04-OCT-94','3498','8.99','5.93');
insert into iself.stocks values ('GUIG','GUI Intl.','43.84','04-OCT-94','368','46.59','28.25');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.19','04-OCT-94','2339','15.19','14.49');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.68','04-OCT-94','5735','12.74','11.52');  
insert into iself.stocks values ('ORCL','Oracle Corp.','91.72','04-OCT-94','1977','91.72','53.12'); 
insert into iself.stocks values ('VICA','Victoria Apparel','49.28','04-OCT-94','842','49.28','37.5');  
insert into iself.stocks values ('MSFT','Microsoft','27.02','04-OCT-94','5254','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','35.8','04-OCT-94','2988','37.28','28.8'); 
insert into iself.stocks values ('CSCO','Cisco Systems','38.53','04-OCT-94','4643','40.17','21.63');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','20.36','04-OCT-94','2172','20.78','18.66'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','33.69','04-OCT-94','4862','34.38','24.88');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','8.29','05-OCT-94','4444','8.99','5.93');
insert into iself.stocks values ('GUIG','GUI Intl.','48.4','05-OCT-94','271','48.4','28.61'); 
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.15','05-OCT-94','1788','15.19','14.49');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.62','05-OCT-94','3329','12.74','11.52');  
insert into iself.stocks values ('ORCL','Oracle Corp.','93.47','05-OCT-94','3350','95.42','53.86'); 
insert into iself.stocks values ('VICA','Victoria Apparel','48.78','05-OCT-94','1206','49.28','37.5'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','05-OCT-94','5292','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','37.25','05-OCT-94','772','37.28','28.8'); 
insert into iself.stocks values ('CSCO','Cisco Systems','40.87','05-OCT-94','2258','40.89','21.78');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','20.38','30-SEP-94','534','20.38','18.58');  
insert into iself.stocks values ('WBTK','Webbe Trucking','33.74','30-SEP-94','2925','33.74','24.75');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.69','30-SEP-94','4232','8.34','5.8'); 
insert into iself.stocks values ('GUIG','GUI Intl.','44.02','30-SEP-94','257','44.02','27.73');  
insert into iself.stocks values ('ALCB','Alaska Corned Beef','20.78','03-OCT-94','1488','20.78','18.66'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','33.71','03-OCT-94','2963','33.74','24.75');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.03','28-SEP-94','1324','15.03','14.45');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.44','28-SEP-94','5994','12.44','11.46');  
insert into iself.stocks values ('ORCL','Oracle Corp.','78.63','28-SEP-94','2103','81.91','51.16'); 
insert into iself.stocks values ('VICA','Victoria Apparel','45.54','28-SEP-94','1553','46','36.85');
insert into iself.stocks values ('MSFT','Microsoft','27.02','28-SEP-94','4552','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','35.89','28-SEP-94','1950','35.89','28.52');  
insert into iself.stocks values ('CSCO','Cisco Systems','35.78','28-SEP-94','4138','36.53','20.91');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','20.38','28-SEP-94','1417','20.38','18.58'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','32.44','28-SEP-94','2822','32.48','24.5');
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.71','28-SEP-94','6256','7.88','5.7'); 
insert into iself.stocks values ('GUIG','GUI Intl.','42.38','28-SEP-94','229','42.38','27.4');
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.07','29-SEP-94','2228','15.07','14.46');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.5','29-SEP-94','5462','12.56','11.49');
insert into iself.stocks values ('ORCL','Oracle Corp.','83.41','29-SEP-94','1882','83.41','51.46'); 
insert into iself.stocks values ('VICA','Victoria Apparel','46.91','29-SEP-94','802','46.92','37.03'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','29-SEP-94','5006','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','34.47','29-SEP-94','2847','35.89','28.52');  
insert into iself.stocks values ('CSCO','Cisco Systems','35.04','29-SEP-94','4419','36.53','20.91');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.98','29-SEP-94','2069','20.38','18.58'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','32.43','29-SEP-94','4630','33.09','24.62');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','8.34','29-SEP-94','3332','8.34','5.8'); 
insert into iself.stocks values ('GUIG','GUI Intl.','39.87','29-SEP-94','352','42.38','27.4');
insert into iself.stocks values ('ULTM','Ultimate Lighting','15.03','30-SEP-94','1704','15.07','14.46');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.44','30-SEP-94','3171','12.56','11.49');  
insert into iself.stocks values ('ORCL','Oracle Corp.','85.01','30-SEP-94','3189','86.78','52.13'); 
insert into iself.stocks values ('VICA','Victoria Apparel','46.43','30-SEP-94','1149','46.92','37.03');
insert into iself.stocks values ('MSFT','Microsoft','27.02','30-SEP-94','5040','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','35.86','30-SEP-94','735','35.89','28.52');
insert into iself.stocks values ('CSCO','Cisco Systems','37.17','30-SEP-94','2151','37.18','21.04');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.95','26-SEP-94','456','14.95','14.44');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.32','26-SEP-94','1878','12.38','11.45');  
insert into iself.stocks values ('ORCL','Oracle Corp.','78.8','26-SEP-94','3745','80.41','50.86');  
insert into iself.stocks values ('VICA','Victoria Apparel','45.54','26-SEP-94','1282','45.54','36.76');
insert into iself.stocks values ('MSFT','Microsoft','27.02','26-SEP-94','5566','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','34.51','26-SEP-94','741','35.21','28.39');
insert into iself.stocks values ('CSCO','Cisco Systems','33.1','26-SEP-94','2803','33.82','20.36'); 
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.98','26-SEP-94','539','19.98','18.5');
insert into iself.stocks values ('WBTK','Webbe Trucking','31.19','26-SEP-94','3674','32.48','24.5');
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.73','26-SEP-94','2360','7.74','5.68');
insert into iself.stocks values ('GUIG','GUI Intl.','40.82','26-SEP-94','360','41.65','27.26');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.91','27-SEP-94','626','14.95','14.44');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.38','27-SEP-94','3443','12.38','11.45');  
insert into iself.stocks values ('ORCL','Oracle Corp.','80.3','27-SEP-94','2177','80.41','50.86');  
insert into iself.stocks values ('VICA','Victoria Apparel','46','27-SEP-94','1194','46','36.85');
insert into iself.stocks values ('MSFT','Microsoft','27.02','27-SEP-94','3456','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','34.5','27-SEP-94','1442','35.21','28.39');
insert into iself.stocks values ('CSCO','Cisco Systems','35.11','27-SEP-94','2812','35.83','20.77');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.98','27-SEP-94','1049','20.18','18.54'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','32.45','27-SEP-94','1807','32.48','24.5');
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.71','27-SEP-94','3894','7.88','5.7'); 
insert into iself.stocks values ('GUIG','GUI Intl.','39.96','27-SEP-94','273','41.65','27.26');  
insert into iself.stocks values ('CSCO','Cisco Systems','31.92','22-SEP-94','2678','32.57','20.11');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.58','22-SEP-94','999','19.78','18.46');  
insert into iself.stocks values ('CSCO','Cisco Systems','32.54','23-SEP-94','3942','33.21','20.24');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.98','23-SEP-94','1350','19.98','18.5');  
insert into iself.stocks values ('WBTK','Webbe Trucking','31.24','23-SEP-94','2688','31.28','24.26');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.15','23-SEP-94','5956','7.31','5.59');
insert into iself.stocks values ('GUIG','GUI Intl.','38.55','23-SEP-94','219','38.55','26.64');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.91','23-SEP-94','1260','14.91','14.43');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.26','23-SEP-94','5706','12.26','11.43');  
insert into iself.stocks values ('ORCL','Oracle Corp.','71.5','23-SEP-94','2004','74.48','49.67');  
insert into iself.stocks values ('VICA','Victoria Apparel','43.36','23-SEP-94','1479','43.84','36.42');
insert into iself.stocks values ('MSFT','Microsoft','27.02','23-SEP-94','4337','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','34.55','23-SEP-94','1857','34.55','28.25');  
insert into iself.stocks values ('WBTK','Webbe Trucking','31.28','20-SEP-94','2652','31.28','24.26');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','6.62','20-SEP-94','3838','7.17','5.56');
insert into iself.stocks values ('GUIG','GUI Intl.','36.4','20-SEP-94','234','36.4','26.21'); 
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.79','20-SEP-94','1542','14.83','14.41');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.08','20-SEP-94','2875','12.2','11.42');
insert into iself.stocks values ('ORCL','Oracle Corp.','70.29','20-SEP-94','2893','71.76','49.13'); 
insert into iself.stocks values ('VICA','Victoria Apparel','42.13','20-SEP-94','1041','42.58','36.16');
insert into iself.stocks values ('MSFT','Microsoft','27.02','20-SEP-94','4571','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','33.24','20-SEP-94','667','33.27','28');
insert into iself.stocks values ('WBTK','Webbe Trucking','30.04','21-SEP-94','3499','31.28','24.26');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.17','21-SEP-94','2246','7.17','5.56');
insert into iself.stocks values ('GUIG','GUI Intl.','37.1','21-SEP-94','340','37.86','26.5'); 
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.83','21-SEP-94','433','14.83','14.41');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.14','21-SEP-94','1787','12.2','11.42');
insert into iself.stocks values ('ORCL','Oracle Corp.','71.65','21-SEP-94','3568','73.11','49.4');  
insert into iself.stocks values ('VICA','Victoria Apparel','43.41','21-SEP-94','1221','43.41','36.33');
insert into iself.stocks values ('MSFT','Microsoft','27.02','21-SEP-94','5299','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','33.22','21-SEP-94','706','33.9','28.12'); 
insert into iself.stocks values ('CSCO','Cisco Systems','30.09','21-SEP-94','2670','30.73','19.75');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.58','21-SEP-94','513','19.6','18.42');
insert into iself.stocks values ('WBTK','Webbe Trucking','31.25','22-SEP-94','1721','31.28','24.26');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.15','22-SEP-94','3708','7.31','5.59');
insert into iself.stocks values ('GUIG','GUI Intl.','36.33','22-SEP-94','258','37.86','26.5');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.79','22-SEP-94','596','14.83','14.41');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.2','22-SEP-94','3279','12.2','11.42'); 
insert into iself.stocks values ('ORCL','Oracle Corp.','73.02','22-SEP-94','2073','73.11','49.4');  
insert into iself.stocks values ('VICA','Victoria Apparel','43.82','22-SEP-94','1135','43.84','36.42');
insert into iself.stocks values ('MSFT','Microsoft','27.02','22-SEP-94','3292','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','33.21','22-SEP-94','1374','33.9','28.12');
insert into iself.stocks values ('CSCO','Cisco Systems','28.96','19-SEP-94','4010','30.18','19.64');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.21','19-SEP-94','1876','19.6','18.42');  
insert into iself.stocks values ('WBTK','Webbe Trucking','30.07','19-SEP-94','4199','30.68','24.14');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','7.17','19-SEP-94','3020','7.17','5.56');
insert into iself.stocks values ('GUIG','GUI Intl.','32.97','19-SEP-94','318','35.04','25.94');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.83','19-SEP-94','2019','14.83','14.41');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','12.14','19-SEP-94','4953','12.2','11.42');
insert into iself.stocks values ('ORCL','Oracle Corp.','68.97','19-SEP-94','1707','68.97','48.57'); 
insert into iself.stocks values ('VICA','Victoria Apparel','42.57','19-SEP-94','727','42.58','36.16'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','19-SEP-94','4538','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','31.95','19-SEP-94','2581','33.27','28');  
insert into iself.stocks values ('CSCO','Cisco Systems','30.72','20-SEP-94','1951','30.73','19.75');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.59','20-SEP-94','485','19.6','18.42');
insert into iself.stocks values ('GUIG','GUI Intl.','33.09','15-SEP-94','222','33.09','25.55');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.67','15-SEP-94','1467','14.71','14.39');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.9','15-SEP-94','2739','12.02','11.38');
insert into iself.stocks values ('ORCL','Oracle Corp.','63.92','15-SEP-94','2755','65.26','47.83'); 
insert into iself.stocks values ('VICA','Victoria Apparel','40.16','15-SEP-94','990','40.59','35.77'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','15-SEP-94','4353','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','32','15-SEP-94','635','32.02','27.75');
insert into iself.stocks values ('CSCO','Cisco Systems','27.92','15-SEP-94','1859','27.93','19.19');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.22','15-SEP-94','461','19.22','18.35');  
insert into iself.stocks values ('WBTK','Webbe Trucking','30.11','15-SEP-94','2526','30.11','24.02');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','6.13','15-SEP-94','3654','6.64','5.46');
insert into iself.stocks values ('GUIG','GUI Intl.','33.72','16-SEP-94','321','34.41','25.81');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.71','16-SEP-94','413','14.71','14.39');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.96','16-SEP-94','1703','12.02','11.38');  
insert into iself.stocks values ('ORCL','Oracle Corp.','65.15','16-SEP-94','3397','66.48','48.07'); 
insert into iself.stocks values ('VICA','Victoria Apparel','41.38','16-SEP-94','1161','41.38','35.92');
insert into iself.stocks values ('MSFT','Microsoft','27.02','16-SEP-94','5047','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','31.99','16-SEP-94','672','32.64','27.87');
insert into iself.stocks values ('CSCO','Cisco Systems','27.34','16-SEP-94','2543','27.93','19.19');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.22','16-SEP-94','488','19.22','18.35');  
insert into iself.stocks values ('WBTK','Webbe Trucking','28.92','16-SEP-94','3333','30.11','24.02');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','6.64','16-SEP-94','2140','6.64','5.46');
insert into iself.stocks values ('GUIG','GUI Intl.','30.04','12-SEP-94','231','31.3','25.19');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.55','12-SEP-94','541','14.59','14.37');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.84','12-SEP-94','2974','11.84','11.34');  
insert into iself.stocks values ('ORCL','Oracle Corp.','60.39','12-SEP-94','1880','60.48','46.87'); 
insert into iself.stocks values ('VICA','Victoria Apparel','39.82','12-SEP-94','1029','39.84','35.62');
insert into iself.stocks values ('MSFT','Microsoft','27.02','12-SEP-94','2984','27.03','27.01'); 
insert into iself.stocks values ('GUIG','GUI Intl.','31.86','13-SEP-94','198','31.86','25.3');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.67','13-SEP-94','1142','14.67','14.38');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.9','13-SEP-94','5177','11.9','11.36'); 
insert into iself.stocks values ('ORCL','Oracle Corp.','59.13','13-SEP-94','1815','61.6','47.1');
insert into iself.stocks values ('VICA','Victoria Apparel','39.4','13-SEP-94','1340','39.84','35.62'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','13-SEP-94','3932','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','32.02','13-SEP-94','1683','32.02','27.75');  
insert into iself.stocks values ('CSCO','Cisco Systems','26.87','13-SEP-94','3575','27.43','19.09');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','19.22','13-SEP-94','1224','19.22','18.35'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','28.95','13-SEP-94','2438','28.98','23.8');
insert into iself.stocks values ('DYTY','Dinosaur Toys','6.13','13-SEP-94','5404','6.26','5.38');
insert into iself.stocks values ('GUIG','GUI Intl.','29.97','14-SEP-94','303','31.86','25.3');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.71','14-SEP-94','1923','14.71','14.39');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.96','14-SEP-94','4717','12.02','11.38');  
insert into iself.stocks values ('ORCL','Oracle Corp.','62.73','14-SEP-94','1624','62.73','47.32'); 
insert into iself.stocks values ('VICA','Victoria Apparel','40.58','14-SEP-94','692','40.59','35.77'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','14-SEP-94','4324','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','30.75','14-SEP-94','2458','32.02','27.75');  
insert into iself.stocks values ('CSCO','Cisco Systems','26.31','14-SEP-94','3816','27.43','19.09');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.84','14-SEP-94','1787','19.22','18.35'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','28.94','14-SEP-94','3999','29.53','23.91');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','6.64','14-SEP-94','2876','6.64','5.46');
insert into iself.stocks values ('VLVO','Volvo','29.61','09-SEP-94','2341','30.83','27.51');  
insert into iself.stocks values ('CSCO','Cisco Systems','23.91','09-SEP-94','3635','24.93','18.59');
insert into iself.stocks values ('VLVO','Volvo','30.77','12-SEP-94','1245','31.42','27.63');  
insert into iself.stocks values ('CSCO','Cisco Systems','26.36','12-SEP-94','2428','26.9','18.98'); 
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.84','12-SEP-94','906','19.03','18.31');  
insert into iself.stocks values ('WBTK','Webbe Trucking','28.96','12-SEP-94','1561','28.98','23.8');
insert into iself.stocks values ('DYTY','Dinosaur Toys','6.13','12-SEP-94','3364','6.26','5.38');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.13','02-SEP-94','820','18.89','18.28');  
insert into iself.stocks values ('WBTK','Webbe Trucking','26.82','02-SEP-94','1416','26.82','23.36');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','5.28','02-SEP-94','3052','5.83','5.39');
insert into iself.stocks values ('GUIG','GUI Intl.','24.79','02-SEP-94','209','28.4','24.61');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.31','02-SEP-94','491','14.5','14.35'); 
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.48','02-SEP-94','2697','11.48','11.27');  
insert into iself.stocks values ('ORCL','Oracle Corp.','49.94','02-SEP-94','1704','49.96','44.77'); 
insert into iself.stocks values ('VICA','Victoria Apparel','36.13','02-SEP-94','933','36.23','34.89'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','02-SEP-94','2704','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','28.54','02-SEP-94','1131','29','27.14');  
insert into iself.stocks values ('CSCO','Cisco Systems','21.76','02-SEP-94','2201','22.28','18.06');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.49','05-SEP-94','418','18.89','18.28');  
insert into iself.stocks values ('WBTK','Webbe Trucking','27.89','05-SEP-94','2291','27.89','23.58');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','5.26','05-SEP-94','3312','5.83','5.29');
insert into iself.stocks values ('GUIG','GUI Intl.','27.35','05-SEP-94','202','28.4','24.61');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.43','05-SEP-94','1331','14.5','14.35');
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.54','05-SEP-94','2484','11.66','11.31');  
insert into iself.stocks values ('ORCL','Oracle Corp.','52.88','05-SEP-94','2498','53.98','45.57'); 
insert into iself.stocks values ('VICA','Victoria Apparel','36.46','05-SEP-94','900','36.85','35.02'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','05-SEP-94','3947','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','29.67','05-SEP-94','575','29.69','27.28');
insert into iself.stocks values ('CSCO','Cisco Systems','23.07','05-SEP-94','1683','23.08','18.22');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.49','06-SEP-94','443','18.89','18.28');  
insert into iself.stocks values ('WBTK','Webbe Trucking','26.78','06-SEP-94','3023','27.89','23.58');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','5.7','06-SEP-94','1940','5.83','5.29'); 
insert into iself.stocks values ('GUIG','GUI Intl.','27.88','06-SEP-94','293','28.45','24.62');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.47','06-SEP-94','374','14.5','14.35'); 
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.6','06-SEP-94','1544','11.66','11.31');
insert into iself.stocks values ('ORCL','Oracle Corp.','53.9','06-SEP-94','3080','55','45.78');  
insert into iself.stocks values ('VICA','Victoria Apparel','37.56','06-SEP-94','1053','37.56','35.16');
insert into iself.stocks values ('MSFT','Microsoft','22.04','06-SEP-94','14575','22.04','19.01');
insert into iself.stocks values ('VLVO','Volvo','29.65','06-SEP-94','610','30.26','27.4'); 
insert into iself.stocks values ('CSCO','Cisco Systems','22.59','06-SEP-94','2304','23.08','18.22');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.48','07-SEP-94','862','18.89','18.28');  
insert into iself.stocks values ('WBTK','Webbe Trucking','27.87','07-SEP-94','1487','27.89','23.58');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','5.68','07-SEP-94','3204','5.83','5.29');
insert into iself.stocks values ('GUIG','GUI Intl.','27.3','07-SEP-94','223','28.45','24.62');
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.43','07-SEP-94','515','14.5','14.35'); 
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.66','07-SEP-94','2832','11.66','11.31');  
insert into iself.stocks values ('ORCL','Oracle Corp.','54.94','07-SEP-94','1791','55','45.78'); 
insert into iself.stocks values ('VICA','Victoria Apparel','37.94','07-SEP-94','980','37.94','35.24'); 
insert into iself.stocks values ('MSFT','Microsoft','27.02','07-SEP-94','2839','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','29.64','07-SEP-94','1186','30.26','27.4');
insert into iself.stocks values ('CSCO','Cisco Systems','23.96','07-SEP-94','2311','24.45','18.49');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.85','08-SEP-94','1166','18.89','18.28'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','27.86','08-SEP-94','2321','27.89','23.58');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','5.68','08-SEP-94','5146','5.83','5.29');
insert into iself.stocks values ('GUIG','GUI Intl.','28.97','08-SEP-94','186','28.97','24.72');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.55','08-SEP-94','1087','14.55','14.36');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.72','08-SEP-94','4929','11.72','11.32');  
insert into iself.stocks values ('ORCL','Oracle Corp.','53.8','08-SEP-94','1730','56.04','45.98');  
insert into iself.stocks values ('VICA','Victoria Apparel','37.56','08-SEP-94','1276','37.94','35.24');
insert into iself.stocks values ('MSFT','Microsoft','27.02','08-SEP-94','3742','27.03','27.01'); 
insert into iself.stocks values ('VLVO','Volvo','30.83','08-SEP-94','1603','30.83','27.51');  
insert into iself.stocks values ('CSCO','Cisco Systems','24.42','08-SEP-94','3403','24.93','18.59');
insert into iself.stocks values ('ALCB','Alaska Corned Beef','18.47','09-SEP-94','1702','18.89','18.28'); 
insert into iself.stocks values ('WBTK','Webbe Trucking','27.85','09-SEP-94','3808','28.42','23.68');  
insert into iself.stocks values ('DYTY','Dinosaur Toys','6.15','09-SEP-94','2738','6.15','5.36');
insert into iself.stocks values ('GUIG','GUI Intl.','27.25','09-SEP-94','287','28.97','24.72');  
insert into iself.stocks values ('ULTM','Ultimate Lighting','14.59','09-SEP-94','1830','14.59','14.37');  
insert into iself.stocks values ('OJSP','OJ Sporting Goods','11.78','09-SEP-94','4492','11.84','11.34');  
insert into iself.stocks values ('ORCL','Oracle Corp.','57.07','09-SEP-94','1549','57.07','46.19'); 
insert into iself.stocks values ('VICA','Victoria Apparel','38.69','09-SEP-94','659','38.7','35.39');  
insert into iself.stocks values ('MSFT','Microsoft','27.02','09-SEP-94','4115','27.03','27.01'); 

insert into iself.stock_history values ('ORCL','64043','53','23','1.2','21','7'); 
insert into iself.stock_history values ('MSFT','23000','57','12','.8','16','3');  
insert into iself.stock_history values ('CSCO','1200','35','8','.23','12','4');
insert into iself.stock_history values ('VLVO','4500','20','9','.45','40','3');
insert into iself.stock_history values ('ALCB','12311','34','8','0','1.2',''); 
insert into iself.stock_history values ('WBTK','12555','35','11','1.2','4','');
insert into iself.stock_history values ('DYTY','66534','34','25','20','1.4','10');
insert into iself.stock_history values ('GUIG','10553','45','23','.85','4','');
insert into iself.stock_history values ('ULTM','3334','18','10','0','12','');  
insert into iself.stock_history values ('OJSP','9533','50','15','1.2','4',''); 
insert into iself.stock_history values ('VICA','3432','36','2','0','30','');

spool off