![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to installPEOPLE.sqloracle6 CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / PeopleDBScripts|
Return to installPEOPLE.sqloracle6 CVS log | Up to [NeXTSTEP 3.3 examples] / Examples / EnterpriseObjects / PeopleDBScripts |
1.1 root 1: /******************************************************************************
2: * Login through sqlplus and paste this text into your terminal window.
3: ******************************************************************************/
4:
5: /******************************************************************************
6: * Drop all the tables.
7: ******************************************************************************/
8: drop table EMPLOYEE ;
9: drop table DEPARTMENT ;
10: drop table FACILITY;
11: drop table PROJECT;
12: drop table EMP_PHOTO ;
13: drop table EMP_QUOTE ;
14: drop table EMP_PROJECT;
15: drop table JOB_TITLE ;
16: drop table EMP_EQUIPMENT ;
17: drop table UNIQUE_KEY ;
18:
19:
20: /******************************************************************************
21: * Create the tables.
22: ******************************************************************************/
23: create table EMPLOYEE (
24: EMP_ID int not null,
25: DEPT_ID int null,
26: LAST_NAME varchar(40) not null,
27: FIRST_NAME varchar(40) not null,
28: PHONE char(12) null,
29: ADDRESS varchar(40) null,
30: CITY varchar(20) null,
31: STATE char(2) null,
32: ZIP char(5) null,
33: TITLE_ID int null,
34: HIRE_DATE date null,
35: MANAGER int null,
36: SALARY number(7,2) null
37: );
38:
39: create table DEPARTMENT (
40: DEPT_ID int not null,
41: DEPARTMENT_NAME varchar(30) not null,
42: LOCATION_ID int not null
43: );
44:
45: create table FACILITY (
46: LOCATION_ID int not null,
47: LOCATION varchar(30) not null,
48: PHOTO long raw null
49: );
50:
51: create table EMP_PROJECT (
52: EMP_ID int,
53: PROJECT_ID int
54: );
55:
56: create table PROJECT (
57: PROJECT_ID int not null,
58: PROJECT_NAME varchar(30) not null,
59: SUMMARYImage long raw
60: );
61:
62: create table EMP_PHOTO (
63: EMP_ID int not null,
64: PHOTO long raw null
65: );
66:
67: create table EMP_QUOTE (
68: EMP_ID int not null,
69: QUOTE long raw null
70: );
71:
72: create table JOB_TITLE (
73: TITLE_ID int not null,
74: TITLE varchar(30) not null,
75: TITLE_TYPE varchar(12)
76: );
77:
78: create table EMP_EQUIPMENT (
79: ASSET_TAG int not null,
80: DESCRIPTION varchar(100) null,
81: SERIAL_NUMBER varchar(20) null,
82: EMP_ID int null
83: );
84:
85:
86: /******************************************************************************
87: * Insert values.
88: ******************************************************************************/
89: insert into FACILITY values(1101, 'Waterfront One', null);
90: insert into FACILITY values(1103, 'Hillside 1', null);
91: insert into FACILITY values(1106, 'Hillside 2', null);
92: insert into FACILITY values(1207, 'Embarcadero', null);
93: insert into FACILITY values(1104, 'Arcada', null);
94:
95: insert into EMP_PROJECT values (101, 501);
96: insert into EMP_PROJECT values (102, 503);
97: insert into EMP_PROJECT values (103, 507);
98: insert into EMP_PROJECT values (104, 510);
99: insert into EMP_PROJECT values (105, 512);
100: insert into EMP_PROJECT values (106, 501);
101: insert into EMP_PROJECT values (107, 503);
102: insert into EMP_PROJECT values (108, 507);
103: insert into EMP_PROJECT values (109, 510);
104: insert into EMP_PROJECT values (110, 512);
105: insert into EMP_PROJECT values (111, 501);
106: insert into EMP_PROJECT values (112, 503);
107: insert into EMP_PROJECT values (113, 507);
108: insert into EMP_PROJECT values (114, 510);
109: insert into EMP_PROJECT values (115, 512);
110: insert into EMP_PROJECT values (116, 501);
111: insert into EMP_PROJECT values (117, 503);
112: insert into EMP_PROJECT values (118, 507);
113: insert into EMP_PROJECT values (119, 510);
114: insert into EMP_PROJECT values (120, 512);
115: insert into EMP_PROJECT values (121, 501);
116: insert into EMP_PROJECT values (122, 503);
117: insert into EMP_PROJECT values (123, 507);
118: insert into EMP_PROJECT values (124, 510);
119: insert into EMP_PROJECT values (125, 512);
120: insert into EMP_PROJECT values (126, 501);
121: insert into EMP_PROJECT values (127, 503);
122: insert into EMP_PROJECT values (128, 507);
123: insert into EMP_PROJECT values (129, 510);
124: insert into EMP_PROJECT values (130, 512);
125: insert into EMP_PROJECT values (131, 501);
126: insert into EMP_PROJECT values (132, 503);
127: insert into EMP_PROJECT values (133, 507);
128: insert into EMP_PROJECT values (134, 510);
129: insert into EMP_PROJECT values (135, 512);
130: insert into EMP_PROJECT values (136, 501);
131: insert into EMP_PROJECT values (137, 503);
132: insert into EMP_PROJECT values (138, 507);
133: insert into EMP_PROJECT values (139, 510);
134: insert into EMP_PROJECT values (140, 512);
135: insert into EMP_PROJECT values (141, 501);
136: insert into EMP_PROJECT values (142, 503);
137: insert into EMP_PROJECT values (143, 507);
138: insert into EMP_PROJECT values (144, 510);
139: insert into EMP_PROJECT values (145, 512);
140: insert into EMP_PROJECT values (146, 501);
141: insert into EMP_PROJECT values (147, 503);
142: insert into EMP_PROJECT values (148, 507);
143: insert into EMP_PROJECT values (149, 510);
144: insert into EMP_PROJECT values (150, 512);
145: insert into EMP_PROJECT values (151, 501);
146: insert into EMP_PROJECT values (152, 503);
147: insert into EMP_PROJECT values (153, 507);
148: insert into EMP_PROJECT values (154, 510);
149: insert into EMP_PROJECT values (155, 512);
150: insert into EMP_PROJECT values (156, 501);
151: insert into EMP_PROJECT values (157, 503);
152: insert into EMP_PROJECT values (158, 507);
153: insert into EMP_PROJECT values (159, 510);
154: insert into EMP_PROJECT values (160, 512);
155: insert into EMP_PROJECT values (161, 501);
156: insert into EMP_PROJECT values (162, 503);
157: insert into EMP_PROJECT values (163, 507);
158: insert into EMP_PROJECT values (164, 510);
159: insert into EMP_PROJECT values (165, 512);
160: insert into EMP_PROJECT values (166, 501);
161: insert into EMP_PROJECT values (167, 503);
162: insert into EMP_PROJECT values (168, 507);
163: insert into EMP_PROJECT values (169, 510);
164: insert into EMP_PROJECT values (170, 512);
165: insert into EMP_PROJECT values (171, 501);
166: insert into EMP_PROJECT values (172, 503);
167: insert into EMP_PROJECT values (173, 507);
168: insert into EMP_PROJECT values (174, 510);
169: insert into EMP_PROJECT values (175, 512);
170: insert into EMP_PROJECT values (176, 501);
171: insert into EMP_PROJECT values (177, 503);
172: insert into EMP_PROJECT values (178, 507);
173: insert into EMP_PROJECT values (179, 510);
174: insert into EMP_PROJECT values (180, 512);
175: insert into EMP_PROJECT values (181, 501);
176: insert into EMP_PROJECT values (182, 503);
177: insert into EMP_PROJECT values (183, 507);
178: insert into EMP_PROJECT values (184, 510);
179: insert into EMP_PROJECT values (185, 512);
180: insert into EMP_PROJECT values (186, 501);
181: insert into EMP_PROJECT values (187, 503);
182: insert into EMP_PROJECT values (188, 507);
183: insert into EMP_PROJECT values (189, 510);
184: insert into EMP_PROJECT values (190, 512);
185: insert into EMP_PROJECT values (191, 501);
186: insert into EMP_PROJECT values (192, 503);
187: insert into EMP_PROJECT values (193, 507);
188: insert into EMP_PROJECT values (194, 510);
189: insert into EMP_PROJECT values (195, 512);
190: insert into EMP_PROJECT values (196, 501);
191: insert into EMP_PROJECT values (197, 503);
192: insert into EMP_PROJECT values (198, 507);
193: insert into EMP_PROJECT values (199, 510);
194: insert into EMP_PROJECT values (200, 512);
195: insert into EMP_PROJECT values (201, 501);
196: insert into EMP_PROJECT values (202, 503);
197: insert into EMP_PROJECT values (203, 507);
198: insert into EMP_PROJECT values (204, 510);
199: insert into EMP_PROJECT values (205, 512);
200: insert into EMP_PROJECT values (206, 501);
201: insert into EMP_PROJECT values (207, 503);
202: insert into EMP_PROJECT values (208, 507);
203: insert into EMP_PROJECT values (209, 510);
204: insert into EMP_PROJECT values (210, 512);
205: insert into EMP_PROJECT values (211, 501);
206: insert into EMP_PROJECT values (212, 503);
207: insert into EMP_PROJECT values (213, 507);
208: insert into EMP_PROJECT values (214, 510);
209: insert into EMP_PROJECT values (215, 512);
210: insert into EMP_PROJECT values (216, 501);
211: insert into EMP_PROJECT values (217, 503);
212: insert into EMP_PROJECT values (218, 507);
213: insert into EMP_PROJECT values (219, 510);
214: insert into EMP_PROJECT values (220, 512);
215: insert into EMP_PROJECT values (221, 501);
216: insert into EMP_PROJECT values (222, 503);
217: insert into EMP_PROJECT values (223, 507);
218: insert into EMP_PROJECT values (224, 510);
219: insert into EMP_PROJECT values (225, 512);
220:
221: insert into PROJECT values( 501, 'BankLink Financials', null);
222: insert into PROJECT values( 503, 'Crossover Environment', null);
223: insert into PROJECT values( 507, 'Net DesignWorks', null);
224: insert into PROJECT values( 510, 'InfoVault', null);
225: insert into PROJECT values( 512, 'Customer Satisfaction', null);
226:
227: insert into DEPARTMENT values (100, 'General and Administration', 1104);
228: insert into DEPARTMENT values (101, 'Office of the President', 1207);
229: insert into DEPARTMENT values (104, 'Reception', 1104);
230: insert into DEPARTMENT values (105, 'Adminstration', 1103);
231: insert into DEPARTMENT values (200, 'Production and Design', 1103);
232: insert into DEPARTMENT values (201, 'Art Design', 1104);
233: insert into DEPARTMENT values (202, 'Hardware Engineering', 1106);
234: insert into DEPARTMENT values (203, 'System Software', 1106);
235: insert into DEPARTMENT values (204, 'User Software', 1101);
236: insert into DEPARTMENT values (250, 'Production', 1106);
237: insert into DEPARTMENT values (252, 'Logistics', 1101);
238: insert into DEPARTMENT values (300, 'Sales and Marketing', 1207);
239: insert into DEPARTMENT values (320, 'Domestic Marketing', 1207);
240: insert into DEPARTMENT values (330, 'International Marketing', 1207);
241: insert into DEPARTMENT values (350, 'Sales', 1207);
242: insert into DEPARTMENT values (400, 'Customer Service', 1106);
243: insert into DEPARTMENT values (405, 'Service Logistics', 1106);
244: insert into DEPARTMENT values (410, 'Customer Front-Line', 1106);
245: insert into DEPARTMENT values (420, 'Customer Back-Line', 1106);
246: insert into DEPARTMENT values (500, 'Personnel', 1101);
247: insert into DEPARTMENT values (900, 'Public Relations', 1104);
248:
249: insert into JOB_TITLE values (1, 'President', 'Salaried');
250: insert into JOB_TITLE values (2, 'Vice President', 'Salaried');
251: insert into JOB_TITLE values (3, 'Director', 'Salaried');
252: insert into JOB_TITLE values (4, 'MANAGER', 'Salaried');
253: insert into JOB_TITLE values (5, 'Engineer', 'Hourly');
254: insert into JOB_TITLE values (6, 'Designer', 'Hourly');
255: insert into JOB_TITLE values (7, 'Sales Representative', 'Salaried');
256: insert into JOB_TITLE values (8, 'Administrator', 'Hourly');
257: insert into JOB_TITLE values (9, 'Customer Representative', 'Hourly');
258: insert into JOB_TITLE values (10, 'Product MANAGER', 'Salaried');
259: insert into JOB_TITLE values (11, 'Benefits and Compensation', 'Hourly');
260: insert into JOB_TITLE values (12, 'Associate', 'Hourly');
261: commit;
262:
263: insert into EMPLOYEE values ( 101, 101, 'Winston', 'James', '415-323-7265',
264: '6269 Washington Ave.', 'Woodside', 'CA', '94160', 1,
265: '14-JAN-89', 101, 5700.00 );
266:
267: insert into EMPLOYEE values ( 102, 200, 'Veasey', 'Kai', '415-323-261 ',
268: '3401 Strand St.', 'Woodside', 'CA', '94153', 2,
269: '19-AUG-91', 1, 4600.00 );
270:
271: insert into EMPLOYEE values ( 103, 400, 'MacAskill', 'Debra', '415-328-4407',
272: '3495 Middlefield Ave.', 'Mountain View', 'CA', '94245', 2,
273: '19-NOV-92', 101, 4300.00 );
274:
275: insert into EMPLOYEE values ( 104, 104, 'Oswald', 'Lesley', '415-321-564 ',
276: '6751 Chowen St.', 'Sunnyvale', 'CA', '94234', 4,
277: '20-JUN-94', 101, 4200.00 );
278:
279: insert into EMPLOYEE values ( 105, 320,'Scheer', 'Janine', '415-327-9345',
280: '295 Poplar Road', 'San Jose', 'CA', '94226', 4,
281: '05-JAN-90', 107, 5700.00 );
282:
283: insert into EMPLOYEE values ( 106, 500, 'Maselli', 'John', '415-328-9769',
284: '3494 Pelican Ave.', 'Palo Alto', 'CA', '94226', 2,
285: '16-APR-90', 101, 4900.00 );
286:
287: insert into EMPLOYEE values ( 107, 300, 'Lunau', 'Ken', '415-322-2815',
288: '7163 York Road', 'Woodside', 'CA', '94174', 2,
289: '12-DEC-91', 101, 5600.00 );
290:
291: insert into EMPLOYEE values ( 108, 203, 'DeKeyser', 'John', '415-326-9241',
292: '5633 High Road', 'Mountain View', 'CA', '94228', 3,
293: '18-NOV-89', 102, 5200.00 );
294:
295: insert into EMPLOYEE values ( 109, 900, 'Windgate', 'Mark', '415-321-3718',
296: '4615 Oak Ave.', 'Oakland', 'CA', '94194', 2,
297: '20-FEB-90', 101, 4000.00 );
298:
299: insert into EMPLOYEE values ( 110, 400,'Walsh', 'Phyllis', '415-327-2599',
300: '3746 Oak Road', 'Palo Alto', 'CA', '94165', 5,
301: '14-AUG-91', 103, 4900.00 );
302:
303: insert into EMPLOYEE values ( 111, 203, 'Quan', 'Merianne', '415-323-9827',
304: '7503 Washington Blvd.', 'Redwood City', 'CA', '94223', 5,
305: '06-APR-88', 102, 4700.00 );
306:
307: insert into EMPLOYEE values ( 112, 300, 'Kanzaki', 'Mark', '415-324-7911',
308: '2709 Kristen St.', 'Woodside', 'CA', '94219', 3,
309: '05-APR-88', 107, 4500.00 );
310:
311: insert into EMPLOYEE values ( 113, 400, 'Helton', 'Dung', '415-320-6474',
312: '4397 Schoman Road', 'Woodside', 'CA', '94173', 5,
313: '09-OCT-90', 103, 5600.00 );
314:
315: insert into EMPLOYEE values ( 114, 200, 'Thiry', 'Greg', '415-326-4613',
316: '3883 Drew Road', 'Redwood City', 'CA', '94198', 10,
317: '13-MAR-88', 102, 4700.00 );
318:
319: insert into EMPLOYEE values ( 115, 400,'Gath', 'Jon', '415-322-1987',
320: '502 Johnson St.', 'Santa Clara', 'CA', '94209', 5,
321: '04-NOV-89', 103, 5100.00 );
322:
323: insert into EMPLOYEE values ( 116, 203, 'Kallimani', 'Yoshinori', '415-322-6335',
324: '7099 Knuth Ave.', 'San Jose', 'CA', '94214', 3,
325: '26-DEC-90', 102, 4200.00 );
326:
327: insert into EMPLOYEE values ( 117, 405, 'Hojnowski', 'Greg', '415-323-2994',
328: '5215 Strand Way', 'Pacific Heights', 'CA', '94209', 5,
329: '25-OCT-92', 103, 5200.00 );
330:
331: insert into EMPLOYEE values ( 118, 300, 'Tautz', 'Denise', '415-322-3937',
332: '7851 Oak Trail', 'Woodside', 'CA', '94181', 10,
333: '03-MAR-92', 107, 5100.00 );
334:
335: insert into EMPLOYEE values ( 119, 500, 'Upson', 'Alex', '415-323-11 ',
336: '1440 Addams Circle', 'Mountain View', 'CA', '94193', 4,
337: '09-SEP-89', 106, 4900.00 );
338:
339: insert into EMPLOYEE values ( 120, 350,'Riley', 'Michael', '415-323-2795',
340: '7747 Pope Road', 'Redwood City', 'CA', '94195', 7,
341: '03-FEB-91', 107, 4300.00 );
342:
343: insert into EMPLOYEE values ( 121, 252, 'Kammerer', 'Sanjay', '415-328-3042',
344: '7331 Walnut Ave.', 'Palo Alto', 'CA', '94178', 5,
345: '09-JAN-90', 102, 4700.00 );
346:
347: insert into EMPLOYEE values ( 122, 405, 'Affinito', 'Jon', '415-326-515 ',
348: '639 Schoman Ave.', 'Woodside', 'CA', '94239', 5,
349: '01-MAY-88', 103, 5000.00 );
350:
351: insert into EMPLOYEE values ( 123, 400, 'Liu', 'Tom', '415-321-1766',
352: '3342 Main St.', 'Sunnyvale', 'CA', '94219', 5,
353: '06-JAN-89', 103, 4700.00 );
354:
355: insert into EMPLOYEE values ( 124, 410, 'Walton', 'Jennifer', '415-324-4697',
356: '2673 France St.', 'Santa Clara', 'CA', '94157', 4,
357: '18-JAN-90', 103, 5700.00 );
358:
359: insert into EMPLOYEE values ( 125, 101,'Page', 'Paul', '415-320-81 ',
360: '2754 Johnson Ave.', 'Redwood City', 'CA', '94170', 4,
361: '18-AUG-92', 101, 4200.00 );
362:
363: insert into EMPLOYEE values ( 126, 105, 'Seng', 'Paul', '415-320-7249',
364: '4876 High Road', 'Half Moon Bay', 'CA', '94171', 6,
365: '02-JUL-88', 101, 5000.00 );
366:
367: insert into EMPLOYEE values ( 127, 101, 'Nelson', 'Andrew', '415-323-1072',
368: '562 Knuth Circle', 'Palo Alto', 'CA', '94164', 11,
369: '14-NOV-88', 101, 5300.00 );
370:
371: insert into EMPLOYEE values ( 128, 252, 'Tucker', 'Karen', '415-323-1180',
372: '1952 Lutece St.', 'Atherton', 'CA', '94195', 5,
373: '12-NOV-89', 102, 5700.00 );
374:
375: insert into EMPLOYEE values ( 129, 410, 'Tavana', 'Jim', '415-321-4763',
376: '7067 Broad Road', 'Woodside', 'CA', '94236', 4,
377: '05-MAY-92', 103, 5500.00 );
378:
379: insert into EMPLOYEE values ( 130, 250,'Paquette', 'Satch', '415-326-4537',
380: '6972 York Road', 'Pacific Heights', 'CA', '94158', 5,
381: '27-APR-92', 102, 4800.00 );
382:
383: insert into EMPLOYEE values ( 131, 350, 'Egner', 'Andy', '415-322-8602',
384: '4106 Poplar St.', 'Redwood City', 'CA', '94246', 7,
385: '03-SEP-90', 107, 5700.00 );
386:
387: insert into EMPLOYEE values ( 132, 104, 'Page', ';pal', '415-323-4670',
388: '859 Poplar St.', 'Redwood City', 'CA', '94218', 6,
389: '27-MAR-89', 101, 5300.00 );
390:
391: insert into EMPLOYEE values ( 133, 203, 'Bay', 'Rosalie', '415-320-3763',
392: '6535 Juneberry Ave.', 'Mountain View', 'CA', '94243', 4,
393: '05-FEB-92', 102, 4300.00 );
394:
395: insert into EMPLOYEE values ( 134, 300, 'Fisk', 'George', '415-326-4655',
396: '4346 Connell Circle', 'Atherton', 'CA', '94211', 3,
397: '01-MAY-91', 107, 5700.00 );
398:
399: insert into EMPLOYEE values ( 135, 252,'Hecker', 'Junko', '415-321-7489',
400: '3930 York Ave.', 'Redwood City', 'CA', '94178', 5,
401: '24-JAN-88', 102, 4700.00 );
402:
403: insert into EMPLOYEE values ( 136, 101, 'Walsh', 'Guiseppe', '415-328-2963',
404: '1209 High Road', 'Atherton', 'CA', '94172', 10,
405: '28-NOV-92', 101, 4200.00 );
406:
407: insert into EMPLOYEE values ( 137, 105, 'Davidson', 'Cary', '415-322-7699',
408: '4773 York St.', 'Santa Clara', 'CA', '94160', 3,
409: '23-MAY-89', 101, 5600.00 );
410:
411: insert into EMPLOYEE values ( 138, 250, 'Burt', 'Elida', '415-324-444 ',
412: '939 Middlefield St.', 'Santa Clara', 'CA', '94232', 5,
413: '06-APR-88', 102, 4500.00 );
414:
415: insert into EMPLOYEE values ( 139, 900, 'Kelleher', 'Leonard', '415-328-569 ',
416: '3481 Knox St.', 'Palo Alto', 'CA', '94246', 12,
417: '27-JUL-90', 109, 4600.00 );
418:
419: insert into EMPLOYEE values ( 140, 203,'Henriquez', 'Dave', '415-320-6936',
420: '3790 Market Road', 'Belmont', 'CA', '94219', 5,
421: '10-OCT-92', 102, 5700.00 );
422:
423: insert into EMPLOYEE values ( 141, 252, 'Fuster', 'Manny', '415-325-3468',
424: '6688 Poplar Blvd.', 'Millbrae', 'CA', '94187', 4,
425: '15-DEC-90', 102, 5100.00 );
426:
427: insert into EMPLOYEE values ( 142, 104, 'Cleary', 'Kathi', '415-320-3912',
428: '2746 Schoman St.', 'Redwood City', 'CA', '94150', 11,
429: '23-NOV-91', 101, 5100.00 );
430:
431: insert into EMPLOYEE values ( 143, 350, 'Moore', 'Debra', '415-326-5087',
432: '4126 Lutece Ave.', 'San Jose', 'CA', '94237', 7,
433: '04-APR-91', 107, 5000.00 );
434:
435: insert into EMPLOYEE values ( 144, 100, 'Hopkins', 'Chris', '415-321-8620',
436: '1482 Elm Ave.', 'Oakland', 'CA', '94198', 7,
437: '13-AUG-91', 101, 5300.00 );
438:
439: insert into EMPLOYEE values ( 145, 204,'Self', 'Jack', '415-325-767 ',
440: '7044 Walnut Road', 'Half Moon Bay', 'CA', '94164', 4,
441: '05-NOV-90', 102, 5500.00 );
442:
443: insert into EMPLOYEE values ( 146, 500, 'Cerbone', 'Mark', '415-322-2943',
444: '7137 Juneberry Road', 'San Francisco', 'CA', '94172', 3,
445: '13-MAY-91', 106, 4300.00 );
446:
447: insert into EMPLOYEE values ( 147, 202, 'Ralston', 'Anne', '415-323-4177',
448: '3599 Beech Ave.', 'Palo Alto', 'CA', '94169', 5,
449: '20-JUL-91', 102, 5000.00 );
450:
451: insert into EMPLOYEE values ( 148, 250, 'Henry', 'John', '415-322-5562',
452: '7645 Lancaster Ave.', 'Belmont', 'CA', '94231', 5,
453: '14-JAN-91', 102, 4500.00 );
454:
455: insert into EMPLOYEE values ( 149, 200, 'Kinney', 'Alex', '415-327-8472',
456: '4044 Hanson St.', 'Mountain View', 'CA', '94239', 6,
457: '24-SEP-90', 102, 5300.00 );
458:
459: insert into EMPLOYEE values ( 150, 420,'Moore', 'James', '415-325-4316',
460: '6425 Broad Ave.', 'Redwood City', 'CA', '94244', 5,
461: '23-AUG-89', 103, 5600.00 );
462:
463: insert into EMPLOYEE values ( 151, 105, 'Nguyen', 'Jorg', '415-322-2523',
464: '5531 Knuth St.', 'Pacific Heights', 'CA', '94192', 11,
465: '27-FEB-90', 101, 5600.00 );
466:
467: insert into EMPLOYEE values ( 152, 330, 'Veasey', 'David', '415-320-1483',
468: '3999 Juneberry Road', 'Belmont', 'CA', '94177', 10,
469: '08-DEC-92', 107, 4400.00 );
470:
471: insert into EMPLOYEE values ( 153, 350, 'Morse', 'Guy', '415-328-6708',
472: '1276 Middlefield Ave.', 'Atherton', 'CA', '94234', 7,
473: '04-APR-91', 107, 4000.00 );
474:
475: insert into EMPLOYEE values ( 154, 350, 'Fordam', 'Donna', '415-320-2744',
476: '7712 Chowen St.', 'Oakland', 'CA', '94215', 7,
477: '21-MAR-90', 107, 4800.00 );
478:
479: insert into EMPLOYEE values ( 155, 320,'Walsh', 'James', '415-323-7264',
480: '3532 Anderson St.', 'San Francisco', 'CA', '94179', 10,
481: '23-AUG-90', 107, 4200.00 );
482:
483: insert into EMPLOYEE values ( 156, 420, 'Fukasawa', 'Ben', '415-327-4471',
484: '5337 Kristen Blvd.', 'Palo Alto', 'CA', '94207', 5,
485: '23-SEP-89', 103, 4300.00 );
486:
487: insert into EMPLOYEE values ( 157, 200, 'Yu', 'Martin', '415-321-9787',
488: '7580 High Ave.', 'Palo Alto', 'CA', '94186', 3,
489: '26-DEC-91', 102, 4800.00 );
490:
491: insert into EMPLOYEE values ( 158, 201, 'Hodor', 'Lee', '415-328-151 ',
492: '2669 Sparrow Ave.', 'Belmont', 'CA', '94194', 6,
493: '22-FEB-88', 102, 4000.00 );
494:
495: insert into EMPLOYEE values ( 159, 203, 'Naroff', 'Unjieng,', '415-322-8693',
496: '5176 Lincoln St.', 'San Francisco', 'CA', '94168', 5,
497: '05-JAN-90', 102, 5300.00 );
498:
499: insert into EMPLOYEE values ( 160, 330,'Lee', 'Eric', '415-326-9238',
500: '3234 Connell St.', 'San Francisco', 'CA', '94198', 3,
501: '22-JAN-89', 107, 4900.00 );
502:
503: insert into EMPLOYEE values ( 161, 330, 'Barber', 'Bart', '415-320-7854',
504: '7277 Shorebird St.', 'Half Moon Bay', 'CA', '94243', 10,
505: '18-JUL-91', 107, 4200.00 );
506:
507: insert into EMPLOYEE values ( 162, 900, 'Patel', 'Jim', '415-322-3915',
508: '2767 Drew St.', 'Sunnyvale', 'CA', '94214', 12,
509: '12-JUL-92', 109, 5400.00 );
510:
511: insert into EMPLOYEE values ( 163, 900, 'Vergnot', 'Glenn', '415-324-287 ',
512: '6882 Connell St.', 'San Francisco', 'CA', '94236', 3,
513: '18-AUG-91', 109, 4300.00 );
514:
515: insert into EMPLOYEE values ( 164, 104, 'Hertz', 'Christian', '415-321-3157',
516: '1884 Pope St.', 'San Jose', 'CA', '94208', 3,
517: '12-OCT-89', 101, 4000.00 );
518:
519: insert into EMPLOYEE values ( 165, 350, 'Etcheverry', 'Jon', '415-328-714 ',
520: '2996 Lutece St.', 'Belmont', 'CA', '94216', 7,
521: '21-FEB-88', 107, 4200.00 );
522:
523: insert into EMPLOYEE values ( 166, 101, 'Burt', 'Alice', '415-320-3192',
524: '5114 Lancaster St.', 'Pacific Heights', 'CA', '94241', 3,
525: '14-OCT-92', 101, 5200.00 );
526:
527: insert into EMPLOYEE values ( 167, 350, 'Novak', 'Russ', '415-326-281 ',
528: '6478 Spruce Trail', 'Mountain View', 'CA', '94185', 7,
529: '13-APR-89', 107, 4900.00 );
530:
531: insert into EMPLOYEE values ( 168, 202, 'Francis', 'Vicki', '415-321-8842',
532: '2391 Broadway Ave.', 'Redwood City', 'CA', '94220', 5,
533: '24-JUL-91', 102, 4200.00 );
534:
535: insert into EMPLOYEE values ( 169, 201, 'Jochims', 'Hal', '415-324-8628',
536: '6030 State Ave.', 'Palo Alto', 'CA', '94217', 6,
537: '21-JUL-92', 102, 4200.00 );
538:
539: insert into EMPLOYEE values ( 170, 900,'Tucker', 'Tom', '415-328-2067',
540: '3258 Wallace St.', 'Mountain View', 'CA', '94246', 12,
541: '18-MAR-88', 109, 4600.00 );
542:
543: insert into EMPLOYEE values ( 171, 252, 'Herald', 'Ellen', '415-321-1238',
544: '674 Addams Road', 'San Francisco', 'CA', '94228', 5,
545: '05-FEB-90', 102, 5300.00 );
546:
547: insert into EMPLOYEE values ( 172, 405, 'Anthony', 'Mitch', '415-322-3205',
548: '5062 Hanson Trail', 'Half Moon Bay', 'CA', '94218', 5,
549: '26-MAY-91', 103, 4600.00 );
550:
551: insert into EMPLOYEE values ( 173, 350, 'Fuster', 'Lane', '415-320-9534',
552: '7796 Main Ave.', 'Sunnyvale', 'CA', '94163', 7,
553: '25-JAN-88', 107, 4300.00 );
554:
555: insert into EMPLOYEE values ( 174, 350, 'Dunham', 'Jim', '415-320-691 ',
556: '3866 Lancaster St.', 'Mountain View', 'CA', '94190', 7,
557: '09-JUL-88', 107, 4700.00 );
558:
559: insert into EMPLOYEE values ( 175, 300,'Ferrante', 'Kristen', '415-324-6344',
560: '6086 Broad Blvd.', 'Sunnyvale', 'CA', '94216', 4,
561: '14-APR-90', 107, 5100.00 );
562:
563: insert into EMPLOYEE values ( 176, 202, 'Manross', 'Ken', '415-325-8979',
564: '2452 Lincoln Blvd.', 'Pacific Heights', 'CA', '94228', 5,
565: '18-FEB-88', 102, 5600.00 );
566:
567: insert into EMPLOYEE values ( 177, 105, 'Dahlbeck', 'Olivier', '415-326-2780',
568: '3510 Wallace Trail', 'Millbrae', 'CA', '94187', 5,
569: '12-MAR-88', 101, 4600.00 );
570:
571: insert into EMPLOYEE values ( 178, 400, 'Meyer', 'Bonnie', '415-324-140 ',
572: '1885 Kristen St.', 'Belmont', 'CA', '94155', 5,
573: '14-JAN-91', 103, 4900.00 );
574:
575: insert into EMPLOYEE values ( 179, 203, 'Lappin', 'Denise', '415-320-2072',
576: '6441 Spruce St.', 'Palo Alto', 'CA', '94198', 5,
577: '20-MAY-92', 102, 5200.00 );
578:
579: insert into EMPLOYEE values ( 180, 100,'Magennis', 'Jerry', '415-320-3085',
580: '2457 Chowen St.', 'Redwood City', 'CA', '94224', 8,
581: '28-DEC-89', 101, 4300.00 );
582:
583: insert into EMPLOYEE values ( 181, 202, 'Law', 'Mike', '415-320-4077',
584: '1683 Roberts Blvd.', 'Oakland', 'CA', '94174', 5,
585: '13-JUL-90', 102, 4700.00 );
586:
587: insert into EMPLOYEE values ( 182, 350, 'Jackson', 'Thomas', '415-320-5390',
588: '3279 Hanson St.', 'Belmont', 'CA', '94177', 7,
589: '08-JUN-91', 107, 5300.00 );
590:
591: insert into EMPLOYEE values ( 183, 320, 'Rokovich', 'Dung', '415-320-7176',
592: '4656 Anderson St.', 'Palo Alto', 'CA', '94210', 10,
593: '26-JUN-91', 107, 5300.00 );
594:
595: insert into EMPLOYEE values ( 184, 105, 'White', 'Curits', '415-320-6492',
596: '175 Kristen St.', 'Belmont', 'CA', '94180', 9,
597: '25-JAN-89', 101, 5000.00 );
598:
599: insert into EMPLOYEE values ( 185, 420,'Yee', 'Peggy', '415-328-1314',
600: '4885 France Ave.', 'Half Moon Bay', 'CA', '94239', 4,
601: '16-AUG-90', 103, 4600.00 );
602:
603: insert into EMPLOYEE values ( 186, 900, 'Derrickson', 'Joy', '415-327-5048',
604: '5708 Elm Ave.', 'Redwood City', 'CA', '94231', 12,
605: '15-AUG-88', 109, 4700.00 );
606:
607: insert into EMPLOYEE values ( 187, 330, 'Steenkamer', 'Jerry', '415-324-4072',
608: '3861 Washington St.', 'San Jose', 'CA', '94238', 4,
609: '06-OCT-91', 107, 5200.00 );
610:
611: insert into EMPLOYEE values ( 188, 252, 'Sridhara', 'Dieter', '415-321-5690',
612: '3025 Lancaster Blvd.', 'Atherton', 'CA', '94233', 5,
613: '07-JUN-88', 102, 4900.00 );
614:
615: insert into EMPLOYEE values ( 189, 100, 'Mikkelsen', 'Rob', '415-321-6689',
616: '4027 Shorebird Ave.', 'Woodside', 'CA', '94188', 9,
617: '12-MAY-91', 101, 4400.00 );
618:
619: insert into EMPLOYEE values ( 190, 500,'Yee', 'Kollivakkam', '415-324-1358',
620: '3271 Knuth St.', 'Palo Alto', 'CA', '94217', 4,
621: '10-JAN-88', 106, 4800.00 );
622:
623: insert into EMPLOYEE values ( 191, 204, 'Guerrero', 'Stephen', '415-321-6736',
624: '6368 Anderson St.', 'Palo Alto', 'CA', '94173', 5,
625: '03-JUN-92', 102, 4600.00 );
626:
627: insert into EMPLOYEE values ( 192, 420, 'Page', 'Michael', '415-321-1199',
628: '7713 Middlefield Ave.', 'Atherton', 'CA', '94194', 5,
629: '23-NOV-88', 103, 4500.00 );
630:
631: insert into EMPLOYEE values ( 193, 350, 'McClung', 'Chad', '415-327-1329',
632: '2902 Connell Ave.', 'Sunnyvale', 'CA', '94181', 7,
633: '25-AUG-88', 107, 4200.00 );
634:
635: insert into EMPLOYEE values ( 194, 104, 'Perka', 'Sam', '415-326-1256',
636: '61 Knox St.', 'Santa Clara', 'CA', '94191', 9,
637: '23-NOV-88', 101, 4900.00 );
638:
639: insert into EMPLOYEE values ( 195, 420,'Sickinghe', 'Sherman', '415-325-2233',
640: '4865 France St.', 'Atherton', 'CA', '94207', 5,
641: '19-JUL-89', 103, 4500.00 );
642:
643: insert into EMPLOYEE values ( 196, 250, 'Welch', 'Robin', '415-328-1833',
644: '7631 Knox Road', 'Mountain View', 'CA', '94153', 5,
645: '21-OCT-91', 102, 4100.00 );
646:
647: insert into EMPLOYEE values ( 197, 105, 'Nardin', 'Larry', '415-321-2064',
648: '6179 Main St.', 'Tiberon', 'CA', '94157', 8,
649: '13-DEC-92', 101, 4600.00 );
650:
651: insert into EMPLOYEE values ( 198, 100, 'Zamarripa', 'Drew', '415-320-2956',
652: '6542 State St.', 'Pacific Heights', 'CA', '94163', 10,
653: '18-JUL-91', 101, 5400.00 );
654:
655: insert into EMPLOYEE values ( 199, 500, 'Edwards', 'John', '415-328-186 ',
656: '1318 Chowen St.', 'Mountain View', 'CA', '94198', 4,
657: '12-JUN-89', 106, 5100.00 );
658:
659: insert into EMPLOYEE values ( 200, 202,'Schrey', 'Scott', '415-323-3258',
660: '4033 Knox Road', 'Woodside', 'CA', '94206', 5,
661: '02-NOV-89', 102, 4000.00 );
662:
663: insert into EMPLOYEE values ( 201, 320, 'Jackson', 'Mike', '415-323-8048',
664: '6956 Spruce St.', 'Mountain View', 'CA', '94187', 10,
665: '12-APR-92', 107, 4700.00 );
666:
667: insert into EMPLOYEE values ( 202, 252, 'Mostofi', 'Richard', '415-324-3019',
668: '1704 Lancaster Road', 'Palo Alto', 'CA', '94206', 5,
669: '12-AUG-89', 102, 4500.00 );
670:
671: insert into EMPLOYEE values ( 203, 410, 'Bonidy', 'Salvatore', '415-322-582 ',
672: '3116 Knuth Ave.', 'Half Moon Bay', 'CA', '94245', 5,
673: '14-APR-92', 103, 5200.00 );
674:
675: insert into EMPLOYEE values ( 204, 101, 'Janssen', 'Gene', '415-327-7614',
676: '648 Washington Way', 'San Jose', 'CA', '94175', 8,
677: '17-APR-88', 1, 4300.00 );
678:
679: insert into EMPLOYEE values ( 205, 252,'Scott', 'Ken', '415-325-3118',
680: '5936 Strand Road', 'Palo Alto', 'CA', '94150', 5,
681: '13-JUL-89', 102, 5700.00 );
682:
683: insert into EMPLOYEE values ( 206, 101, 'Droulers', 'Matt', '415-322-213 ',
684: '4617 Roberts Blvd.', 'Sunnyvale', 'CA', '94232', 7,
685: '23-NOV-90', 101, 4400.00 );
686:
687: insert into EMPLOYEE values ( 207, 202, 'Pinkerton', 'Matt', '415-324-6350',
688: '7803 Sparrow Road', 'Woodside', 'CA', '94245', 4,
689: '06-JUL-91', 102, 5600.00 );
690:
691: insert into EMPLOYEE values ( 208, 202, 'Campetelli', 'Margaret', '415-321-2664',
692: '7435 Strand Blvd.', 'Redwood City', 'CA', '94200', 5,
693: '19-SEP-92', 102, 5200.00 );
694:
695: insert into EMPLOYEE values ( 209, 410, 'Lee', 'Jerry', '415-325-9499',
696: '1484 Adams St.', 'Tiberon', 'CA', '94191', 5,
697: '11-JAN-91', 103, 5000.00 );
698:
699: insert into EMPLOYEE values ( 210, 250,'Bucher', 'Fred', '415-323-8440',
700: '7048 Knox Road', 'Palo Alto', 'CA', '94243', 3,
701: '18-MAY-88', 102, 4000.00 );
702:
703: insert into EMPLOYEE values ( 211, 400, 'Farah', 'David', '415-322-2744',
704: '1691 Pelican St.', 'San Francisco', 'CA', '94242', 5,
705: '17-MAR-88', 103, 4600.00 );
706:
707: insert into EMPLOYEE values ( 212, 350, 'Avenell', 'Perry', '415-328-1319',
708: '5910 Lutece Road', 'Palo Alto', 'CA', '94172', 7,
709: '09-MAY-92', 107, 5500.00 );
710:
711: insert into EMPLOYEE values ( 213, 200, 'Butler', 'Mike', '415-327-8235',
712: '5872 Regent Ave.', 'Palo Alto', 'CA', '94226', 11,
713: '05-MAY-90', 102, 5400.00 );
714:
715: insert into EMPLOYEE values ( 214, 405, 'Graves', 'David', '415-323-6928',
716: '5706 Shorebird Road', 'Sunnyvale', 'CA', '94173', 5,
717: '14-NOV-92', 103, 4100.00 );
718:
719: insert into EMPLOYEE values ( 215, 350,'Hourvitz', 'Keith', '415-326-7210',
720: '1092 Pelican St.', 'Sunnyvale', 'CA', '94185', 7,
721: '06-MAR-89', 107, 5400.00 );
722:
723: insert into EMPLOYEE values ( 216, 105, 'Messer', 'Tushar', '415-322-2698',
724: '7117 Drew Road', 'Tiberon', 'CA', '94201', 3,
725: '21-FEB-90', 101, 4800.00 );
726:
727: insert into EMPLOYEE values ( 217, 101, 'Bumgarner', 'Kristen', '415-321-2840',
728: '2039 Adams St.', 'Belmont', 'CA', '94174', 9,
729: '17-APR-88', 101, 5600.00 );
730:
731: insert into EMPLOYEE values ( 218, 201, 'Derrickson', 'Ben', '415-322-5122',
732: '513 Connell St.', 'Tiberon', 'CA', '94176', 6,
733: '15-AUG-88', 102, 4900.00 );
734:
735: insert into EMPLOYEE values ( 219, 101, 'Rushin', 'Mark', '415-323-5883',
736: '5391 Addams St.', 'Redwood City', 'CA', '94221', 6,
737: '14-OCT-89', 101, 4900.00 );
738:
739: insert into EMPLOYEE values ( 220, 100,'Graffagnino', 'Susan', '415-323-3617',
740: '5999 Walnut Circle', 'Tiberon', 'CA', '94239', 7,
741: '06-JAN-92', 101, 4400.00 );
742:
743: insert into EMPLOYEE values ( 221, 202, 'Gibbons', 'Jim', '415-326-9370',
744: '2305 Emerson St.', 'Millbrae', 'CA', '94188', 4,
745: '13-NOV-88', 102, 4700.00 );
746:
747: insert into EMPLOYEE values ( 222, 101, 'Wasmeier', 'Ken', '415-326-6257',
748: '7802 Schoman St.', 'Atherton', 'CA', '94159', 8,
749: '05-NOV-90', 101, 5300.00 );
750:
751: insert into EMPLOYEE values ( 223, 405, 'Joseph', 'Ralph', '415-325-6536',
752: '3635 France St.', 'San Jose', 'CA', '94199', 5,
753: '15-MAY-89', 103, 4100.00 );
754:
755: insert into EMPLOYEE values ( 224, 201, 'Fried', 'Joel', '415-320-9111',
756: '1493 Roberts St.', 'Palo Alto', 'CA', '94196', 6,
757: '02-APR-89', 102, 5200.00 );
758:
759: insert into EMPLOYEE values ( 225, 410,'Blumenfeld', 'Linda', '415-321-2818',
760: '4373 Roberts St.', 'Mountain View', 'CA', '94195', 5,
761: '11-JUN-91', 103, 5700.00 );
762: commit;
763:
764: insert into EMP_PHOTO(EMP_ID) values (101);
765: insert into EMP_PHOTO(EMP_ID) values (102);
766: insert into EMP_PHOTO(EMP_ID) values (103);
767: insert into EMP_PHOTO(EMP_ID) values (104);
768: insert into EMP_PHOTO(EMP_ID) values (105);
769: insert into EMP_PHOTO(EMP_ID) values (106);
770: insert into EMP_PHOTO(EMP_ID) values (107);
771: insert into EMP_PHOTO(EMP_ID) values (108);
772: insert into EMP_PHOTO(EMP_ID) values (109);
773: insert into EMP_PHOTO(EMP_ID) values (110);
774: insert into EMP_PHOTO(EMP_ID) values (111);
775: insert into EMP_PHOTO(EMP_ID) values (112);
776: insert into EMP_PHOTO(EMP_ID) values (113);
777: insert into EMP_PHOTO(EMP_ID) values (114);
778: insert into EMP_PHOTO(EMP_ID) values (115);
779: insert into EMP_PHOTO(EMP_ID) values (116);
780: insert into EMP_PHOTO(EMP_ID) values (117);
781: insert into EMP_PHOTO(EMP_ID) values (118);
782: insert into EMP_PHOTO(EMP_ID) values (119);
783: insert into EMP_PHOTO(EMP_ID) values (120);
784: insert into EMP_PHOTO(EMP_ID) values (121);
785: insert into EMP_PHOTO(EMP_ID) values (122);
786: insert into EMP_PHOTO(EMP_ID) values (123);
787: insert into EMP_PHOTO(EMP_ID) values (124);
788: insert into EMP_PHOTO(EMP_ID) values (125);
789: insert into EMP_PHOTO(EMP_ID) values (126);
790: insert into EMP_PHOTO(EMP_ID) values (127);
791: insert into EMP_PHOTO(EMP_ID) values (128);
792: insert into EMP_PHOTO(EMP_ID) values (129);
793: insert into EMP_PHOTO(EMP_ID) values (130);
794: insert into EMP_PHOTO(EMP_ID) values (131);
795: insert into EMP_PHOTO(EMP_ID) values (132);
796: insert into EMP_PHOTO(EMP_ID) values (133);
797: insert into EMP_PHOTO(EMP_ID) values (134);
798: insert into EMP_PHOTO(EMP_ID) values (135);
799: insert into EMP_PHOTO(EMP_ID) values (136);
800: insert into EMP_PHOTO(EMP_ID) values (137);
801: insert into EMP_PHOTO(EMP_ID) values (138);
802: insert into EMP_PHOTO(EMP_ID) values (139);
803: insert into EMP_PHOTO(EMP_ID) values (140);
804: insert into EMP_PHOTO(EMP_ID) values (141);
805: insert into EMP_PHOTO(EMP_ID) values (142);
806: insert into EMP_PHOTO(EMP_ID) values (143);
807: insert into EMP_PHOTO(EMP_ID) values (144);
808: insert into EMP_PHOTO(EMP_ID) values (145);
809: insert into EMP_PHOTO(EMP_ID) values (146);
810: insert into EMP_PHOTO(EMP_ID) values (147);
811: insert into EMP_PHOTO(EMP_ID) values (148);
812: insert into EMP_PHOTO(EMP_ID) values (149);
813: insert into EMP_PHOTO(EMP_ID) values (150);
814: insert into EMP_PHOTO(EMP_ID) values (151);
815: insert into EMP_PHOTO(EMP_ID) values (152);
816: insert into EMP_PHOTO(EMP_ID) values (153);
817: insert into EMP_PHOTO(EMP_ID) values (154);
818: insert into EMP_PHOTO(EMP_ID) values (155);
819: insert into EMP_PHOTO(EMP_ID) values (156);
820: insert into EMP_PHOTO(EMP_ID) values (157);
821: insert into EMP_PHOTO(EMP_ID) values (158);
822: insert into EMP_PHOTO(EMP_ID) values (159);
823: insert into EMP_PHOTO(EMP_ID) values (160);
824: insert into EMP_PHOTO(EMP_ID) values (161);
825: insert into EMP_PHOTO(EMP_ID) values (162);
826: insert into EMP_PHOTO(EMP_ID) values (163);
827: insert into EMP_PHOTO(EMP_ID) values (164);
828: insert into EMP_PHOTO(EMP_ID) values (165);
829: insert into EMP_PHOTO(EMP_ID) values (166);
830: insert into EMP_PHOTO(EMP_ID) values (167);
831: insert into EMP_PHOTO(EMP_ID) values (168);
832: insert into EMP_PHOTO(EMP_ID) values (169);
833: insert into EMP_PHOTO(EMP_ID) values (170);
834: insert into EMP_PHOTO(EMP_ID) values (171);
835: insert into EMP_PHOTO(EMP_ID) values (172);
836: insert into EMP_PHOTO(EMP_ID) values (173);
837: insert into EMP_PHOTO(EMP_ID) values (174);
838: insert into EMP_PHOTO(EMP_ID) values (175);
839: insert into EMP_PHOTO(EMP_ID) values (176);
840: insert into EMP_PHOTO(EMP_ID) values (177);
841: insert into EMP_PHOTO(EMP_ID) values (178);
842: insert into EMP_PHOTO(EMP_ID) values (179);
843: insert into EMP_PHOTO(EMP_ID) values (180);
844: insert into EMP_PHOTO(EMP_ID) values (181);
845: insert into EMP_PHOTO(EMP_ID) values (182);
846: insert into EMP_PHOTO(EMP_ID) values (183);
847: insert into EMP_PHOTO(EMP_ID) values (184);
848: insert into EMP_PHOTO(EMP_ID) values (185);
849: insert into EMP_PHOTO(EMP_ID) values (186);
850: insert into EMP_PHOTO(EMP_ID) values (187);
851: insert into EMP_PHOTO(EMP_ID) values (188);
852: insert into EMP_PHOTO(EMP_ID) values (189);
853: insert into EMP_PHOTO(EMP_ID) values (190);
854: insert into EMP_PHOTO(EMP_ID) values (191);
855: insert into EMP_PHOTO(EMP_ID) values (192);
856: insert into EMP_PHOTO(EMP_ID) values (193);
857: insert into EMP_PHOTO(EMP_ID) values (194);
858: insert into EMP_PHOTO(EMP_ID) values (195);
859: insert into EMP_PHOTO(EMP_ID) values (196);
860: insert into EMP_PHOTO(EMP_ID) values (197);
861: insert into EMP_PHOTO(EMP_ID) values (198);
862: insert into EMP_PHOTO(EMP_ID) values (199);
863: insert into EMP_PHOTO(EMP_ID) values (200);
864: insert into EMP_PHOTO(EMP_ID) values (201);
865: insert into EMP_PHOTO(EMP_ID) values (202);
866: insert into EMP_PHOTO(EMP_ID) values (203);
867: insert into EMP_PHOTO(EMP_ID) values (204);
868: insert into EMP_PHOTO(EMP_ID) values (205);
869: insert into EMP_PHOTO(EMP_ID) values (206);
870: insert into EMP_PHOTO(EMP_ID) values (207);
871: insert into EMP_PHOTO(EMP_ID) values (208);
872: insert into EMP_PHOTO(EMP_ID) values (209);
873: insert into EMP_PHOTO(EMP_ID) values (210);
874: insert into EMP_PHOTO(EMP_ID) values (211);
875: insert into EMP_PHOTO(EMP_ID) values (212);
876: insert into EMP_PHOTO(EMP_ID) values (213);
877: insert into EMP_PHOTO(EMP_ID) values (214);
878: insert into EMP_PHOTO(EMP_ID) values (215);
879: insert into EMP_PHOTO(EMP_ID) values (216);
880: insert into EMP_PHOTO(EMP_ID) values (217);
881: insert into EMP_PHOTO(EMP_ID) values (218);
882: insert into EMP_PHOTO(EMP_ID) values (219);
883: insert into EMP_PHOTO(EMP_ID) values (220);
884: insert into EMP_PHOTO(EMP_ID) values (221);
885: insert into EMP_PHOTO(EMP_ID) values (222);
886: insert into EMP_PHOTO(EMP_ID) values (223);
887: insert into EMP_PHOTO(EMP_ID) values (224);
888: insert into EMP_PHOTO(EMP_ID) values (225);
889: commit;
890:
891:
892: insert into EMP_EQUIPMENT values (1100, 'NeXTstation 8/105', '984-9749', 119);
893: insert into EMP_EQUIPMENT values (1101, 'NeXTstation 8/105', '929-22249', 149);
894: insert into EMP_EQUIPMENT values (1102, 'NeXTstation Color 8/105', '397-40272', 166);
895: insert into EMP_EQUIPMENT values (1103, 'NeXTstation Color 16/200', '233-86445', 127);
896: insert into EMP_EQUIPMENT values (1104, 'NeXTstation 16/400', '207-53910', 131);
897: insert into EMP_EQUIPMENT values (1105, 'NeXTstation Color Turbo 16/200', '508-67548', 147);
898: insert into EMP_EQUIPMENT values (1106, 'NeXTstation 16/200', '436-80755', 161);
899: insert into EMP_EQUIPMENT values (1107, 'NeXTstation Color Turbo 16/200', '543-37393', 156);
900: insert into EMP_EQUIPMENT values (1108, 'NeXTstation 16/200', '547-30645', 218);
901: insert into EMP_EQUIPMENT values (1109, 'NeXTstation 8/105', '476-93085', 178);
902: insert into EMP_EQUIPMENT values (1110, 'NeXTDimension', '336-24689', 137);
903: insert into EMP_EQUIPMENT values (1111, 'NeXTstation Turbo 16/400', '549-35596', 193);
904: insert into EMP_EQUIPMENT values (1112, 'NeXTstation Color 8/105', '26-33143', 144);
905: insert into EMP_EQUIPMENT values (1113, 'NeXTstation Color Turbo 8/105', '393-60933', 164);
906: insert into EMP_EQUIPMENT values (1114, 'NeXTstation Color 8/105', '748-91478', 184);
907: insert into EMP_EQUIPMENT values (1115, 'NeXTDimension', '754-23106', 140);
908: insert into EMP_EQUIPMENT values (1116, 'NeXTstation Color Turbo 16/400', '372-28680', 152);
909: insert into EMP_EQUIPMENT values (1117, 'NeXTstation Color 16/400', '13-44241', 211);
910: insert into EMP_EQUIPMENT values (1118, 'NeXTstation Color Turbo 16/200', '539-51330', 214);
911: insert into EMP_EQUIPMENT values (1119, 'NeXTstation Color 16/200', '418-68918', 103);
912: insert into EMP_EQUIPMENT values (1120, 'NeXTstation 16/200', '809-46727', 143);
913: insert into EMP_EQUIPMENT values (1121, 'NeXTstation 8/105', '279-2385', 118);
914: insert into EMP_EQUIPMENT values (1122, 'NeXTstation Color Turbo 16/200', '414-69939', 179);
915: insert into EMP_EQUIPMENT values (1123, 'NeXTstation Color Turbo 16/200', '796-69543', 188);
916: insert into EMP_EQUIPMENT values (1124, 'NeXTstation Color Turbo 16/200', '537-89239', 154);
917: insert into EMP_EQUIPMENT values (1125, 'NeXTstation 16/400', '541-23964', 198);
918: insert into EMP_EQUIPMENT values (1126, 'NeXTstation Turbo 16/400', '178-21075', 113);
919: insert into EMP_EQUIPMENT values (1127, 'NeXTstation 16/200', '243-74685', 183);
920: insert into EMP_EQUIPMENT values (1128, 'NeXTstation 16/400', '702-51108', 138);
921: insert into EMP_EQUIPMENT values (1129, 'NeXTstation 16/200', '193-79563', 171);
922: insert into EMP_EQUIPMENT values (1130, 'NeXTstation Color 16/200', '595-86545', 160);
923: insert into EMP_EQUIPMENT values (1131, 'NeXTstation Color 16/200', '226-22739', 210);
924: insert into EMP_EQUIPMENT values (1132, 'NeXTstation Turbo 16/400', '98-6934', 204);
925: insert into EMP_EQUIPMENT values (1133, 'NeXTstation 16/400', '513-28929', 134);
926: insert into EMP_EQUIPMENT values (1134, 'NeXTstation 8/105', '349-4738', 163);
927: insert into EMP_EQUIPMENT values (1135, 'NeXTstation Color Turbo 16/200', '941-66087', 132);
928: insert into EMP_EQUIPMENT values (1136, 'NeXTstation Color 16/400', '382-65389', 114);
929: insert into EMP_EQUIPMENT values (1137, 'NeXTstation 16/400', '664-62232', 117);
930: insert into EMP_EQUIPMENT values (1138, 'NeXTstation Color 8/105', '5-36913', 136);
931: insert into EMP_EQUIPMENT values (1139, 'NeXTstation Color 16/400', '370-90496', 153);
932: insert into EMP_EQUIPMENT values (1140, 'NeXTDimension', '984-7872', 169);
933: insert into EMP_EQUIPMENT values (1141, 'NeXTstation Color 16/400', '277-34231', 145);
934: insert into EMP_EQUIPMENT values (1142, 'NeXTstation 16/400', '753-51711', 150);
935: insert into EMP_EQUIPMENT values (1143, 'NeXTstation Color Turbo 8/105', '123-7629', 155);
936: insert into EMP_EQUIPMENT values (1144, 'NeXTstation 16/400', '800-3038', 124);
937: insert into EMP_EQUIPMENT values (1145, 'NeXTstation Color 8/105', '486-77628', 180);
938: insert into EMP_EQUIPMENT values (1146, 'NeXTstation 8/105', '824-13576', 187);
939: insert into EMP_EQUIPMENT values (1147, 'NeXTstation Color 8/105', '626-42240', 209);
940: insert into EMP_EQUIPMENT values (1148, 'NeXTstation Color Turbo 8/105', '781-27064', 129);
941: insert into EMP_EQUIPMENT values (1149, 'NeXTstation Color Turbo 16/200', '914-13130', 162);
942: insert into EMP_EQUIPMENT values (1150, 'NeXTstation Turbo 16/400', '95-49295', 174);
943: insert into EMP_EQUIPMENT values (1151, 'NeXTstation Color 8/105', '647-96907', 221);
944: insert into EMP_EQUIPMENT values (1152, 'NeXTDimension', '117-87463', 224);
945: insert into EMP_EQUIPMENT values (1153, 'NeXTstation Color Turbo 16/200', '670-29606', 106);
946: insert into EMP_EQUIPMENT values (1154, 'NeXTstation 16/400', '332-52077', 148);
947: insert into EMP_EQUIPMENT values (1155, 'NeXTstation Color 16/200', '852-63799', 199);
948: insert into EMP_EQUIPMENT values (1156, 'NeXTstation Color 8/105', '440-37613', 115);
949: insert into EMP_EQUIPMENT values (1157, 'NeXTstation Color Turbo 16/400', '298-58959', 122);
950: insert into EMP_EQUIPMENT values (1158, 'NeXTstation Color Turbo 8/105', '164-40348', 165);
951: insert into EMP_EQUIPMENT values (1159, 'NeXTstation Color Turbo 8/105', '975-497', 151);
952: insert into EMP_EQUIPMENT values (1160, 'NeXTstation Color 16/200', '741-12300', 186);
953: insert into EMP_EQUIPMENT values (1161, 'NeXTstation 8/105', '126-40700', 135);
954: insert into EMP_EQUIPMENT values (1162, 'NeXTstation 16/200', '923-50658', 102);
955: insert into EMP_EQUIPMENT values (1163, 'NeXTstation Color Turbo 16/200', '705-40124', 105);
956: insert into EMP_EQUIPMENT values (1164, 'NeXTstation Color 16/400', '985-27011', 128);
957: insert into EMP_EQUIPMENT values (1165, 'NeXTstation 16/400', '83-84294', 142);
958: insert into EMP_EQUIPMENT values (1166, 'NeXTstation 16/400', '233-32050', 215);
959: insert into EMP_EQUIPMENT values (1167, 'NeXTstation 16/400', '226-34036', 107);
960: insert into EMP_EQUIPMENT values (1168, 'NeXTDimension', '524-60536', 176);
961: insert into EMP_EQUIPMENT values (1169, 'NeXTstation 8/105', '104-65265', 205);
962: insert into EMP_EQUIPMENT values (1170, 'NeXTstation Color Turbo 16/400', '794-54450', 222);
963: insert into EMP_EQUIPMENT values (1171, 'NeXTstation Color 16/200', '550-87024', 190);
964: insert into EMP_EQUIPMENT values (1172, 'NeXTstation 16/200', '75-57330', 175);
965: insert into EMP_EQUIPMENT values (1173, 'NeXTstation 16/200', '709-24372', 217);
966: insert into EMP_EQUIPMENT values (1174, 'NeXTstation Color Turbo 16/200', '388-38271', 173);
967: insert into EMP_EQUIPMENT values (1175, 'NeXTstation 8/105', '98-76041', 197);
968: insert into EMP_EQUIPMENT values (1176, 'NeXTstation Color Turbo 8/105', '767-36932', 158);
969: insert into EMP_EQUIPMENT values (1177, 'NeXTstation 8/105', '595-13623', 139);
970: insert into EMP_EQUIPMENT values (1178, 'NeXTstation 8/105', '664-82207', 104);
971: insert into EMP_EQUIPMENT values (1179, 'NeXTDimension', '830-38108', 225);
972: insert into EMP_EQUIPMENT values (1180, 'NeXTstation Color 16/200', '281-5023', 141);
973: insert into EMP_EQUIPMENT values (1181, 'NeXTstation Color Turbo 16/200', '388-51896', 208);
974: insert into EMP_EQUIPMENT values (1182, 'NeXTDimension', '813-75150', 109);
975: insert into EMP_EQUIPMENT values (1183, 'NeXTstation Color 8/105', '576-43283', 112);
976: insert into EMP_EQUIPMENT values (1184, 'NeXTstation 16/200', '563-21410', 146);
977: insert into EMP_EQUIPMENT values (1185, 'NeXTstation Color 8/105', '384-26683', 219);
978: insert into EMP_EQUIPMENT values (1186, 'NeXTDimension', '449-97816', 157);
979: insert into EMP_EQUIPMENT values (1187, 'NeXTstation 8/105', '853-64862', 206);
980: insert into EMP_EQUIPMENT values (1188, 'NeXTstation 8/105', '621-8809', 207);
981: insert into EMP_EQUIPMENT values (1189, 'NeXTstation 16/200', '162-25658', 111);
982: insert into EMP_EQUIPMENT values (1190, 'NeXTstation Color 8/105', '621-29151', 120);
983: insert into EMP_EQUIPMENT values (1191, 'NeXTstation Color Turbo 16/400', '63-38117', 192);
984: insert into EMP_EQUIPMENT values (1192, 'NeXTstation Color Turbo 16/200', '704-39748', 181);
985: insert into EMP_EQUIPMENT values (1193, 'NeXTstation 8/105', '785-84375', 201);
986: insert into EMP_EQUIPMENT values (1194, 'NeXTstation Color 16/400', '652-37816', 213);
987: insert into EMP_EQUIPMENT values (1195, 'NeXTstation Color 16/200', '886-84102', 172);
988: insert into EMP_EQUIPMENT values (1196, 'NeXTstation Color Turbo 16/200', '831-87177', 108);
989: insert into EMP_EQUIPMENT values (1197, 'NeXTstation Color Turbo 16/200', '739-26210', 177);
990: insert into EMP_EQUIPMENT values (1198, 'NeXTstation 16/200', '396-71735', 125);
991: insert into EMP_EQUIPMENT values (1199, 'NeXTstation 16/400', '34-79809', 126);
992: insert into EMP_EQUIPMENT values (1200, 'NeXTstation Color 8/105', '334-59161', 185);
993: insert into EMP_EQUIPMENT values (1201, 'NeXTDimension', '524-41124', 212);
994: insert into EMP_EQUIPMENT values (1202, 'NeXTstation Color 8/105', '836-89146', 110);
995: insert into EMP_EQUIPMENT values (1203, 'NeXTstation Color 16/400', '608-57474', 223);
996: insert into EMP_EQUIPMENT values (1204, 'NeXTstation Color Turbo 16/200', '722-85049', 202);
997: insert into EMP_EQUIPMENT values (1205, 'NeXTstation Color Turbo 16/400', '532-78167', 189);
998: insert into EMP_EQUIPMENT values (1206, 'NeXTstation Turbo 16/400', '16-926', 196);
999: insert into EMP_EQUIPMENT values (1207, 'NeXTstation Turbo 16/400', '518-18514', 133);
1000: insert into EMP_EQUIPMENT values (1208, 'NeXTDimension', '384-72591', 167);
1001: insert into EMP_EQUIPMENT values (1209, 'NeXTDimension', '334-21983', 203);
1002: insert into EMP_EQUIPMENT values (1210, 'NeXTstation Color Turbo 16/200', '391-49812', 194);
1003: insert into EMP_EQUIPMENT values (1211, 'NeXTstation Turbo 16/400', '6-87480', 121);
1004: insert into EMP_EQUIPMENT values (1212, 'NeXTstation Color Turbo 16/200', '197-13972', 130);
1005: insert into EMP_EQUIPMENT values (1213, 'NeXTstation Color 16/400', '33-39584', 200);
1006: insert into EMP_EQUIPMENT values (1214, 'NeXTstation Color 16/200', '992-3848', 195);
1007: insert into EMP_EQUIPMENT values (1215, 'NeXTstation Color Turbo 8/105', '277-10448', 101);
1008: insert into EMP_EQUIPMENT values (1216, 'NeXTstation Color Turbo 16/400', '975-77088', 191);
1009: insert into EMP_EQUIPMENT values (1217, 'NeXTstation Turbo 16/400', '294-32339', 220);
1010: insert into EMP_EQUIPMENT values (1218, 'NeXTDimension', '618-27833', 182);
1011: insert into EMP_EQUIPMENT values (1219, 'NeXTstation 16/400', '103-83650', 123);
1012: insert into EMP_EQUIPMENT values (1220, 'NeXTstation Color Turbo 16/200', '756-14950', 170);
1013: insert into EMP_EQUIPMENT values (1221, 'NeXTstation 16/400', '436-91312', 216);
1014: insert into EMP_EQUIPMENT values (1222, 'NeXTstation Color Turbo 16/200', '489-13117', 159);
1015: insert into EMP_EQUIPMENT values (1223, 'NeXTstation Color Turbo 8/105', '579-12221', 168);
1016: insert into EMP_EQUIPMENT values (1224, 'NeXTstation 16/400', '551-13204', 116);
1017:
1018: insert into EMP_QUOTE(EMP_ID) select EMP_ID from EMPLOYEE;
1019: commit;
1020:
1021:
1022: /******************************************************************************
1023: * Create table indexes.
1024: ******************************************************************************/
1025: create unique index EMP_INDEX1 on EMPLOYEE(EMP_ID);
1026: create unique index DEPT_INDEX1 on DEPARTMENT(DEPT_ID);
1027: create unique index FACILITY_INDEX1 on FACILITY(LOCATION_ID);
1028: create unique index PROJ_INDEX1 on PROJECT(PROJECT_ID);
1029: create unique index EMP_PROJ_INDEX1 on EMP_PROJECT(EMP_ID,PROJECT_ID);
1030: create unique index EMP_PHOTO_INDEX1 on EMP_PHOTO(EMP_ID);
1031: create unique index EMP_QUOTE_INDEX1 on EMP_QUOTE(EMP_ID);
1032: create unique index JOB_TITLE_INDEX1 on JOB_TITLE(TITLE_ID);
1033: create unique index ASSET_INDEX1 on EMP_EQUIPMENT(ASSET_TAG);
1034: commit;
1035:
1036:
1037: /******************************************************************************
1038: * Create the UNIQUE_KEY table, which stores the MAX_KEY for each ENTITY_NAME.
1039: ******************************************************************************/
1040: create table UNIQUE_KEY
1041: (ENTITY_NAME varchar(100) not null,
1042: MAX_KEY int not null
1043: );
1044:
1045: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMPLOYEE',max(EMP_ID) from EMPLOYEE;
1046: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'DEPARTMENT',max(DEPT_ID) from DEPARTMENT;
1047: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'FACILITY',max(LOCATION_ID) from FACILITY;
1048: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'PROJECT',max(PROJECT_ID) from PROJECT;
1049: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'JOB_TITLE',max(TITLE_ID) from JOB_TITLE;
1050: insert into UNIQUE_KEY (ENTITY_NAME,MAX_KEY) select 'EMP_EQUIPMENT',max(ASSET_TAG) from EMP_EQUIPMENT;
1051:
1052: create unique INDEX UNIQUE_KEY_INDEX1 on UNIQUE_KEY(ENTITY_NAME);
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.