--Save this file on your computer, for example under c:\temp --Log into the Oracle Database using the Administrator account --At the command prompt, type @c:\temp\student.txt and hit the [Enter] key --This script will install all necessary tables and other related objects. DROP USER student cascade / Create User student identified by hr / GRANT CREATE SESSION TO student WITH ADMIN OPTION / GRANT Connect TO student / Grant Resource TO student / GRANT CREATE TABLE TO student / GRANT CREATE USER TO student / GRANT ALTER USER TO student / GRANT DROP USER TO student / GRANT CREATE VIEW TO student / GRANT CREATE TRIGGER TO student / GRANT SELECT ANY TABLE TO student WITH ADMIN OPTION / conn student/hr CREATE TABLE "REGIONS" ( "REGION_ID" NUMBER CONSTRAINT "REGION_ID_NN" NOT NULL ENABLE, "REGION_NAME" VARCHAR2(25), CONSTRAINT "REG_ID_PK" PRIMARY KEY ("REGION_ID") ENABLE ) / CREATE TABLE "COUNTRIES" ( "COUNTRY_ID" CHAR(2) CONSTRAINT "COUNTRY_ID_NN" NOT NULL ENABLE, "COUNTRY_NAME" VARCHAR2(40), "REGION_ID" NUMBER, CONSTRAINT "COUNTRY_C_ID_PK" PRIMARY KEY ("COUNTRY_ID") ENABLE, CONSTRAINT "COUNTR_REG_FK" FOREIGN KEY ("REGION_ID") REFERENCES "REGIONS" ("REGION_ID") ENABLE ) ORGANIZATION INDEX NOCOMPRESS / CREATE TABLE "LOCATIONS" ( "LOCATION_ID" NUMBER(4,0), "STREET_ADDRESS" VARCHAR2(40), "POSTAL_CODE" VARCHAR2(12), "CITY" VARCHAR2(30) CONSTRAINT "LOC_CITY_NN" NOT NULL ENABLE, "STATE_PROVINCE" VARCHAR2(25), "COUNTRY_ID" CHAR(2), CONSTRAINT "LOC_ID_PK" PRIMARY KEY ("LOCATION_ID") ENABLE, CONSTRAINT "LOC_C_ID_FK" FOREIGN KEY ("COUNTRY_ID") REFERENCES "COUNTRIES" ("COUNTRY_ID") ENABLE ) / CREATE TABLE "DEPARTMENTS" ( "DEPARTMENT_ID" NUMBER(4,0), "DEPARTMENT_NAME" VARCHAR2(30) CONSTRAINT "DEPT_NAME_NN" NOT NULL ENABLE, "MANAGER_ID" NUMBER(6,0), "LOCATION_ID" NUMBER(4,0), CONSTRAINT "DEPT_ID_PK" PRIMARY KEY ("DEPARTMENT_ID") ENABLE, CONSTRAINT "DEPT_LOC_FK" FOREIGN KEY ("LOCATION_ID") REFERENCES "LOCATIONS" ("LOCATION_ID") ENABLE -- ,CONSTRAINT "DEPT_MGR_FK" FOREIGN KEY ("MANAGER_ID") -- REFERENCES "EMPLOYEES" ("EMPLOYEE_ID") ENABLE ) / CREATE TABLE "JOBS" ( "JOB_ID" VARCHAR2(10), "JOB_TITLE" VARCHAR2(35) CONSTRAINT "JOB_TITLE_NN" NOT NULL ENABLE, "MIN_SALARY" NUMBER(6,0), "MAX_SALARY" NUMBER(6,0), CONSTRAINT "JOB_ID_PK" PRIMARY KEY ("JOB_ID") ENABLE ) / CREATE TABLE "EMPLOYEES" ( "EMPLOYEE_ID" NUMBER(6,0), "FIRST_NAME" VARCHAR2(20), "LAST_NAME" VARCHAR2(25) CONSTRAINT "EMP_LAST_NAME_NN" NOT NULL ENABLE, "EMAIL" VARCHAR2(25) CONSTRAINT "EMP_EMAIL_NN" NOT NULL ENABLE, "PHONE_NUMBER" VARCHAR2(20), "HIRE_DATE" DATE CONSTRAINT "EMP_HIRE_DATE_NN" NOT NULL ENABLE, "JOB_ID" VARCHAR2(10) CONSTRAINT "EMP_JOB_NN" NOT NULL ENABLE, "SALARY" NUMBER(8,2), "COMMISSION_PCT" NUMBER(2,2), "MANAGER_ID" NUMBER(6,0), "DEPARTMENT_ID" NUMBER(4,0), CONSTRAINT "EMP_EMP_ID_PK" PRIMARY KEY ("EMPLOYEE_ID") ENABLE, CONSTRAINT "EMP_DEPT_FK" FOREIGN KEY ("DEPARTMENT_ID") REFERENCES "DEPARTMENTS" ("DEPARTMENT_ID") ENABLE, CONSTRAINT "EMP_JOB_FK" FOREIGN KEY ("JOB_ID") REFERENCES "JOBS" ("JOB_ID") ENABLE, CONSTRAINT "EMP_MANAGER_FK" FOREIGN KEY ("MANAGER_ID") REFERENCES "EMPLOYEES" ("EMPLOYEE_ID") ENABLE ) / CREATE TABLE "JOB_HISTORY" ( "EMPLOYEE_ID" NUMBER(6,0) CONSTRAINT "JHIST_EMPLOYEE_NN" NOT NULL ENABLE, "START_DATE" DATE CONSTRAINT "JHIST_START_DATE_NN" NOT NULL ENABLE, "END_DATE" DATE CONSTRAINT "JHIST_END_DATE_NN" NOT NULL ENABLE, "JOB_ID" VARCHAR2(10) CONSTRAINT "JHIST_JOB_NN" NOT NULL ENABLE, "DEPARTMENT_ID" NUMBER(4,0), CONSTRAINT "JHIST_DATE_INTERVAL" CHECK (end_date > start_date) ENABLE, CONSTRAINT "JHIST_EMP_ID_ST_DATE_PK" PRIMARY KEY ("EMPLOYEE_ID", "START_DATE") ENABLE, CONSTRAINT "JHIST_JOB_FK" FOREIGN KEY ("JOB_ID") REFERENCES "JOBS" ("JOB_ID") ENABLE, CONSTRAINT "JHIST_EMP_FK" FOREIGN KEY ("EMPLOYEE_ID") REFERENCES "EMPLOYEES" ("EMPLOYEE_ID") ENABLE, CONSTRAINT "JHIST_DEPT_FK" FOREIGN KEY ("DEPARTMENT_ID") REFERENCES "DEPARTMENTS" ("DEPARTMENT_ID") ENABLE ) / CREATE TABLE "SAL_GRADE" ( "GRADE" VARCHAR2(1), "MIN_SAL" NUMBER, "MAX_SAL" NUMBER ) / CREATE TABLE "SAL_HISTORY" ( "EMPLOYEE_ID" NUMBER(6,0), "HIRE_DATE" DATE , "SALARY" NUMBER(8,2) ) / CREATE TABLE "MGR_HISTORY" ( "EMPLOYEE_ID" NUMBER(6,0), "MANAGER_ID" NUMBER(6,0) , "SALARY" NUMBER(8,2) ) / CREATE TABLE "SALES_BY_QUARTER" ( "YEAR" VARCHAR2(4), "Q1" NUMBER(10,2), "Q2" NUMBER(10,2), "Q3" NUMBER(10,2), "Q4" NUMBER(10,2) ) / CREATE TABLE "SALARY_RAISE" ("EMPLOYEE_ID" NUMBER(6,0), "PAY_RAISE" NUMBER(6,2), "EFF_DATE" Date); INSERT INTO SALEs_BY_QUARTER VALUES('2005',54863.25,48574.58,36897.12,65874.15) / INSERT INTO SALEs_BY_QUARTER VALUES('2006',84833.14,58743.25,28564.28,58744.35) / CREATE TABLE "SALES" ( "YEAR" VARCHAR2(4), "Quarter" VARCHAR2(1), "SALES" NUMBER(10,2) ) / CREATE TABLE bonus( employee_id NUMBER(6,0), bonus NUMBER(8,2) DEFAULT 100 ) / CREATE INDEX "LOC_STATE_PROVINCE_IX" ON "LOCATIONS" ("STATE_PROVINCE") / CREATE INDEX "LOC_COUNTRY_IX" ON "LOCATIONS" ("COUNTRY_ID") / CREATE INDEX "LOC_CITY_IX" ON "LOCATIONS" ("CITY") / CREATE INDEX "JHIST_JOB_IX" ON "JOB_HISTORY" ("JOB_ID") / CREATE INDEX "JHIST_EMPLOYEE_IX" ON "JOB_HISTORY" ("EMPLOYEE_ID") / CREATE INDEX "JHIST_DEPARTMENT_IX" ON "JOB_HISTORY" ("DEPARTMENT_ID") / CREATE INDEX "EMP_NAME_IX" ON "EMPLOYEES" ("LAST_NAME", "FIRST_NAME") / CREATE INDEX "EMP_MANAGER_IX" ON "EMPLOYEES" ("MANAGER_ID") / CREATE INDEX "EMP_JOB_IX" ON "EMPLOYEES" ("JOB_ID") / CREATE INDEX "EMP_DEPARTMENT_IX" ON "EMPLOYEES" ("DEPARTMENT_ID") / CREATE INDEX "DEPT_LOCATION_IX" ON "DEPARTMENTS" ("LOCATION_ID") / CREATE SEQUENCE "LOCATIONS_SEQ" MINVALUE 1 MAXVALUE 9900 INCREMENT BY 100 START WITH 3300 NOCACHE NOORDER NOCYCLE / CREATE SEQUENCE "EMPLOYEES_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 207 NOCACHE NOORDER NOCYCLE / CREATE SEQUENCE "DEPARTMENTS_SEQ" MINVALUE 1 MAXVALUE 9990 INCREMENT BY 10 START WITH 280 NOCACHE NOORDER NOCYCLE / --inserting into regions INSERT INTO regions Values(1,'Europe') / INSERT INTO regions Values(2,'Americas') / INSERT INTO regions Values(3,'Asia') / INSERT INTO regions Values(4,'Middle East and Africa') / --inserting into countries INSERT INTO countries values('AR','Argentina',2) / INSERT INTO countries values('AU','Australia',3) / INSERT INTO countries values('BE','Belgium',1) / INSERT INTO countries values('BR','Brazil',2) / INSERT INTO countries values('CA','Canada',2) / INSERT INTO countries values('CH','Switzerland',1) / INSERT INTO countries values('CN','China',3) / INSERT INTO countries values('DE','Germany',1) / INSERT INTO countries values('DK','Denmark',1) / INSERT INTO countries values('EG','Egypt',4) / INSERT INTO countries values('FR','France',1) / INSERT INTO countries values('HK','HongKong',3) / INSERT INTO countries values('IL','Israel',4) / INSERT INTO countries values('IN','India',3) / INSERT INTO countries values('IT','Italy',1) / INSERT INTO countries values('JP','Japan',3) / INSERT INTO countries values('KW','Kuwait',4) / INSERT INTO countries values('MX','Mexico',2) / INSERT INTO countries values('NG','Nigeria',4) / INSERT INTO countries values('NL','Netherlands',1) / INSERT INTO countries values('SG','Singapore',3) / INSERT INTO countries values('UK','United Kingdom',1) / INSERT INTO countries values('US','United States of America',2) / INSERT INTO countries values('ZM','Zambia',4) / INSERT INTO countries values('ZW','Zimbabwe',4) / --inserting into locations INSERT INTO locations values(1000,'1297 Via Cola di Rie','00989','Roma','','IT') / INSERT INTO locations values(1100,'93091 Calle della Testa','10934','Venice','','IT') / INSERT INTO locations values(1200,'2017 Shinjuku-ku','1689','Tokyo','Tokyo Prefecture','JP') / INSERT INTO locations values(1300,'9450 Kamiya-cho','6823','Hiroshima','','JP') / INSERT INTO locations values(1400,'2014 Jabberwocky Rd','26192','Southlake','Texas','US') / INSERT INTO locations values(1500,'2011 Interiors Blvd','99236','South San Francisco','California','US') / INSERT INTO locations values(1600,'2007 Zagora St','50090','South Brunswick','New Jersey','US') / INSERT INTO locations values(1700,'2004 Charade Rd','98199','Seattle','Washington','US') / INSERT INTO locations values(1800,'147 Spadina Ave','M5V 2L7','Toronto','Ontario','CA') / INSERT INTO locations values(1900,'6092 Boxwood St','YSW 9T2','Whitehorse','Yukon','CA') / INSERT INTO locations values(2000,'40-5-12 Laogianggen','190518','Beijing','','CN') / INSERT INTO locations values(2100,'1298 Vileparle (E)','490231','Bombay','Maharashtra','IN') / INSERT INTO locations values(2200,'12-98 Victoria Street','2901','Sydney','New South Wales','AU') / INSERT INTO locations values(2300,'198 Clementi North','540198','Singapore','','SG') / INSERT INTO locations values(2400,'8204 Arthur St','','London','','UK') / INSERT INTO locations values(2500,'Magdalen Centre, The Oxford Science Park','OX9 9ZB','Oxford','Oxford','UK') / INSERT INTO locations values(2600,'9702 Chester Road','09629850293','Stretford','Manchester','UK') / INSERT INTO locations values(2700,'Schwanthalerstr. 7031','80925','Munich','Bavaria','DE') / INSERT INTO locations values(2800,'Rua Frei Caneca 1360 ','01307-002','Sao Paulo','Sao Paulo','BR') / INSERT INTO locations values(2900,'20 Rue des Corps-Saints','1730','Geneva','Geneve','CH') / INSERT INTO locations values(3000,'Murtenstrasse 921','3095','Bern','BE','CH') / INSERT INTO locations values(3100,'Pieter Breughelstraat 837','3029SK','Utrecht','Utrecht','NL') / INSERT INTO locations values(3200,'Mariano Escobedo 9991','11932','Mexico City','Distrito Federal,','MX') / --inserting into departments INSERT INTO departments values(10,'Administration',200,1700) / INSERT INTO departments values(20,'Marketing',201,1800) / INSERT INTO departments values(30,'Purchasing',114,1700) / INSERT INTO departments values(40,'Human Resources',203,2400) / INSERT INTO departments values(50,'Shipping',121,1500) / INSERT INTO departments values(60,'IT',103,1400) / INSERT INTO departments values(70,'Public Relations',204,2700) / INSERT INTO departments values(80,'Sales',145,2500) / INSERT INTO departments values(90,'Executive',100,1700) / INSERT INTO departments values(100,'Finance',108,1700) / INSERT INTO departments values(110,'Accounting',205,1700) / INSERT INTO departments values(120,'Treasury',Null,1700) / INSERT INTO departments values(130,'Corporate Tax',Null,1700) / INSERT INTO departments values(140,'Control And Credit',Null,1700) / INSERT INTO departments values(150,'Shareholder Services',Null,1700) / INSERT INTO departments values(160,'Benefits',Null,1700) / INSERT INTO departments values(170,'Manufacturing',Null,1700) / INSERT INTO departments values(180,'Construction',Null,1700) / INSERT INTO departments values(190,'Contracting',Null,1700) / INSERT INTO departments values(200,'Operations',Null,1700) / INSERT INTO departments values(210,'IT Support',Null,1700) / INSERT INTO departments values(220,'NOC',Null,1700) / INSERT INTO departments values(230,'IT Helpdesk',Null,1700) / INSERT INTO departments values(240,'Government Sales',Null,1700) / INSERT INTO departments values(250,'Retail Sales',Null,1700) / INSERT INTO departments values(260,'Recruiting',Null,1700) / INSERT INTO departments values(270,'Payroll',Null,1700) / --inserting into jobs INSERT INTO jobs values('AD_PRES','President',20000,40000) / INSERT INTO jobs values('AD_VP','Administration Vice President',15000,30000) / INSERT INTO jobs values('AD_ASST','Administration Assistant',3000,6000) / INSERT INTO jobs values('FI_MGR','Finance Manager',8200,16000) / INSERT INTO jobs values('FI_ACCOUNT','Accountant',4200,9000) / INSERT INTO jobs values('AC_MGR','Accounting Manager',8200,16000) / INSERT INTO jobs values('AC_ACCOUNT','Public Accountant',4200,9000) / INSERT INTO jobs values('SA_MAN','Sales Manager',10000,20000) / INSERT INTO jobs values('SA_REP','Sales Representative',6000,12000) / INSERT INTO jobs values('PU_MAN','Purchasing Manager',8000,15000) / INSERT INTO jobs values('PU_CLERK','Purchasing Clerk',2500,5500) / INSERT INTO jobs values('ST_MAN','Stock Manager',5500,8500) / INSERT INTO jobs values('ST_CLERK','Stock Clerk',2000,5000) / INSERT INTO jobs values('SH_CLERK','Shipping Clerk',2500,5500) / INSERT INTO jobs values('IT_PROG','Programmer',4000,10000) / INSERT INTO jobs values('MK_MAN','Marketing Manager',9000,15000) / INSERT INTO jobs values('MK_REP','Marketing Representative',4000,9000) / INSERT INTO jobs values('HR_REP','Human Resources Representative',4000,9000) / INSERT INTO jobs values('PR_REP','Public Relations Representative',4500,10500) / --inserting into employees table INSERT INTO employees values(100,'Steven','King','SKING','515.123.4567',to_date('17-JUN-87','dd-mon-RR'),'AD_PRES',24000,Null,Null,90) / INSERT INTO employees values(101,'Neena','Kochhar','NKOCHHAR','515.123.4568',to_date('21-SEP-89','dd-mon-RR'),'AD_VP',17000,Null,100,90) / INSERT INTO employees values(102,'Lex','De Haan','LDEHAAN','515.123.4569',to_date('13-JAN-93','dd-mon-RR'),'AD_VP',17000,Null,100,90) / INSERT INTO employees values(103,'Alexander','Hunold','AHUNOLD','590.423.4567',to_date('03-JAN-90','dd-mon-RR'),'IT_PROG',9000,Null,102,60) / INSERT INTO employees values(104,'Bruce','Ernst','BERNST','590.423.4568',to_date('21-MAY-91','dd-mon-RR'),'IT_PROG',6000,Null,103,60) / INSERT INTO employees values(105,'David','Austin','DAUSTIN','590.423.4569',to_date('25-JUN-97','dd-mon-RR'),'IT_PROG',4800,Null,103,60) / INSERT INTO employees values(106,'Valli','Pataballa','VPATABAL','590.423.4560',to_date('05-FEB-98','dd-mon-RR'),'IT_PROG',4800,Null,103,60) / INSERT INTO employees values(107,'Diana','Lorentz','DLORENTZ','590.423.5567',to_date('07-FEB-99','dd-mon-RR'),'IT_PROG',4200,Null,103,60) / INSERT INTO employees values(108,'Nancy','Greenberg','NGREENBE','515.124.4569',to_date('17-AUG-94','dd-mon-RR'),'FI_MGR',12000,Null,101,100) / INSERT INTO employees values(109,'Daniel','Faviet','DFAVIET','515.124.4169',to_date('16-AUG-94','dd-mon-RR'),'FI_ACCOUNT',9000,Null,108,100) / INSERT INTO employees values(110,'John','Chen','JCHEN','515.124.4269',to_date('28-SEP-97','dd-mon-RR'),'FI_ACCOUNT',8200,Null,108,100) / INSERT INTO employees values(111,'Ismael','Sciarra','ISCIARRA','515.124.4369',to_date('30-SEP-97','dd-mon-RR'),'FI_ACCOUNT',7700,Null,108,100) / INSERT INTO employees values(112,'Jose Manuel','Urman','JMURMAN','515.124.4469',to_date('07-MAR-98','dd-mon-RR'),'FI_ACCOUNT',7800,Null,108,100) / INSERT INTO employees values(113,'Luis','Popp','LPOPP','515.124.4567',to_date('07-DEC-99','dd-mon-RR'),'FI_ACCOUNT',6900,Null,108,100) / INSERT INTO employees values(114,'Den','Raphaely','DRAPHEAL','515.127.4561',to_date('07-DEC-94','dd-mon-RR'),'PU_MAN',11000,Null,100,30) / INSERT INTO employees values(115,'Alexander','Khoo','AKHOO','515.127.4562',to_date('18-MAY-95','dd-mon-RR'),'PU_CLERK',3100,Null,114,30) / INSERT INTO employees values(116,'Shelli','Baida','SBAIDA','515.127.4563',to_date('24-DEC-97','dd-mon-RR'),'PU_CLERK',2900,Null,114,30) / INSERT INTO employees values(117,'Sigal','Tobias','STOBIAS','515.127.4564',to_date('24-JUL-97','dd-mon-RR'),'PU_CLERK',2800,Null,114,30) / INSERT INTO employees values(118,'Guy','Himuro','GHIMURO','515.127.4565',to_date('15-NOV-98','dd-mon-RR'),'PU_CLERK',2600,Null,114,30) / INSERT INTO employees values(119,'Karen','Colmenares','KCOLMENA','515.127.4566',to_date('10-AUG-99','dd-mon-RR'),'PU_CLERK',2500,Null,114,30) / INSERT INTO employees values(120,'Matthew','Weiss','MWEISS','650.123.1234',to_date('18-JUL-96','dd-mon-RR'),'ST_MAN',8000,Null,100,50) / INSERT INTO employees values(121,'Adam','Fripp','AFRIPP','650.123.2234',to_date('10-APR-97','dd-mon-RR'),'ST_MAN',8200,Null,100,50) / INSERT INTO employees values(122,'Payam','Kaufling','PKAUFLIN','650.123.3234',to_date('01-MAY-95','dd-mon-RR'),'ST_MAN',7900,Null,100,50) / INSERT INTO employees values(123,'Shanta','Vollman','SVOLLMAN','650.123.4234',to_date('10-OCT-97','dd-mon-RR'),'ST_MAN',6500,Null,100,50) / INSERT INTO employees values(124,'Kevin','Mourgos','KMOURGOS','650.123.5234',to_date('16-NOV-99','dd-mon-RR'),'ST_MAN',5800,Null,100,50) / INSERT INTO employees values(125,'Julia','Nayer','JNAYER','650.124.1214',to_date('16-JUL-97','dd-mon-RR'),'ST_CLERK',3200,Null,120,50) / INSERT INTO employees values(126,'Irene','Mikkilineni','IMIKKILI','650.124.1224',to_date('28-SEP-98','dd-mon-RR'),'ST_CLERK',2700,Null,120,50) / INSERT INTO employees values(127,'James','Landry','JLANDRY','650.124.1334',to_date('14-JAN-99','dd-mon-RR'),'ST_CLERK',2400,Null,120,50) / INSERT INTO employees values(128,'Steven','Markle','SMARKLE','650.124.1434',to_date('08-MAR-00','dd-mon-RR'),'ST_CLERK',2200,Null,120,50) / INSERT INTO employees values(129,'Laura','Bissot','LBISSOT','650.124.5234',to_date('20-AUG-97','dd-mon-RR'),'ST_CLERK',3300,Null,121,50) / INSERT INTO employees values(130,'Mozhe','Atkinson','MATKINSO','650.124.6234',to_date('30-OCT-97','dd-mon-RR'),'ST_CLERK',2800,Null,121,50) / INSERT INTO employees values(131,'James','Marlow','JAMRLOW','650.124.7234',to_date('16-FEB-97','dd-mon-RR'),'ST_CLERK',2500,Null,121,50) / INSERT INTO employees values(132,'TJ','Olson','TJOLSON','650.124.8234',to_date('10-APR-99','dd-mon-RR'),'ST_CLERK',2100,Null,121,50) / INSERT INTO employees values(133,'Jason','Mallin','JMALLIN','650.127.1934',to_date('14-JUN-96','dd-mon-RR'),'ST_CLERK',3300,Null,122,50) / INSERT INTO employees values(134,'Michael','Rogers','MROGERS','650.127.1834',to_date('26-AUG-98','dd-mon-RR'),'ST_CLERK',2900,Null,122,50) / INSERT INTO employees values(135,'Ki','Gee','KGEE','650.127.1734',to_date('12-DEC-99','dd-mon-RR'),'ST_CLERK',2400,Null,122,50) / INSERT INTO employees values(136,'Hazel','Philtanker','HPHILTAN','650.127.1634',to_date('06-FEB-00','dd-mon-RR'),'ST_CLERK',2200,Null,122,50) / INSERT INTO employees values(137,'Renske','Ladwig','RLADWIG','650.121.1234',to_date('14-JUL-95','dd-mon-RR'),'ST_CLERK',3600,Null,123,50) / INSERT INTO employees values(138,'Stephen','Stiles','SSTILES','650.121.2034',to_date('26-OCT-97','dd-mon-RR'),'ST_CLERK',3200,Null,123,50) / INSERT INTO employees values(139,'John','Seo','JSEO','650.121.2019',to_date('12-FEB-98','dd-mon-RR'),'ST_CLERK',2700,Null,123,50) / INSERT INTO employees values(140,'Joshua','Patel','JPATEL','650.121.1834',to_date('06-APR-98','dd-mon-RR'),'ST_CLERK',2500,Null,123,50) / INSERT INTO employees values(141,'Trenna','Rajs','TRAJS','650.121.8009',to_date('17-OCT-95','dd-mon-RR'),'ST_CLERK',3500,Null,124,50) / INSERT INTO employees values(142,'Curtis','Davies','CDAVIES','650.121.2994',to_date('29-JAN-97','dd-mon-RR'),'ST_CLERK',3100,Null,124,50) / INSERT INTO employees values(143,'Randall','Matos','RMATOS','650.121.2874',to_date('15-MAR-98','dd-mon-RR'),'ST_CLERK',2600,Null,124,50) / INSERT INTO employees values(144,'Peter','Vargas','PVARGAS','650.121.2004',to_date('09-JUL-98','dd-mon-RR'),'ST_CLERK',2500,Null,124,50) / INSERT INTO employees values(145,'John','Russell','JRUSSEL','011.44.1344.429268',to_date('01-OCT-96','dd-mon-RR'),'SA_MAN',14000,.4,100,80) / INSERT INTO employees values(146,'Karen','Partners','KPARTNER','011.44.1344.467268',to_date('05-JAN-97','dd-mon-RR'),'SA_MAN',13500,.3,100,80) / INSERT INTO employees values(147,'Alberto','Errazuriz','AERRAZUR','011.44.1344.429278',to_date('10-MAR-97','dd-mon-RR'),'SA_MAN',12000,.3,100,80) / INSERT INTO employees values(148,'Gerald','Cambrault','GCAMBRAU','011.44.1344.619268',to_date('15-OCT-99','dd-mon-RR'),'SA_MAN',11000,.3,100,80) / INSERT INTO employees values(149,'Eleni','Zlotkey','EZLOTKEY','011.44.1344.429018',to_date('29-JAN-00','dd-mon-RR'),'SA_MAN',10500,.2,100,80) / INSERT INTO employees values(150,'Peter','Tucker','PTUCKER','011.44.1344.129268',to_date('30-JAN-97','dd-mon-RR'),'SA_REP',10000,.3,145,80) / INSERT INTO employees values(151,'David','Bernstein','DBERNSTE','011.44.1344.345268',to_date('24-MAR-97','dd-mon-RR'),'SA_REP',9500,.25,145,80) / INSERT INTO employees values(152,'Peter','Hall','PHALL','011.44.1344.478968',to_date('20-AUG-97','dd-mon-RR'),'SA_REP',9000,.25,145,80) / INSERT INTO employees values(153,'Christopher','Olsen','COLSEN','011.44.1344.498718',to_date('30-MAR-98','dd-mon-RR'),'SA_REP',8000,.2,145,80) / INSERT INTO employees values(154,'Nanette','Cambrault','NCAMBRAU','011.44.1344.987668',to_date('09-DEC-98','dd-mon-RR'),'SA_REP',7500,.2,145,80) / INSERT INTO employees values(155,'Oliver','Tuvault','OTUVAULT','011.44.1344.486508',to_date('23-NOV-99','dd-mon-RR'),'SA_REP',7000,.15,145,80) / INSERT INTO employees values(156,'Janette','King','JKING','011.44.1345.429268',to_date('30-JAN-96','dd-mon-RR'),'SA_REP',10000,.35,146,80) / INSERT INTO employees values(157,'Patrick','Sully','PSULLY','011.44.1345.929268',to_date('04-MAR-96','dd-mon-RR'),'SA_REP',9500,.35,146,80) / INSERT INTO employees values(158,'Allan','McEwen','AMCEWEN','011.44.1345.829268',to_date('01-AUG-96','dd-mon-RR'),'SA_REP',9000,.35,146,80) / INSERT INTO employees values(159,'Lindsey','Smith','LSMITH','011.44.1345.729268',to_date('10-MAR-97','dd-mon-RR'),'SA_REP',8000,.3,146,80) / INSERT INTO employees values(160,'Louise','Doran','LDORAN','011.44.1345.629268',to_date('15-DEC-97','dd-mon-RR'),'SA_REP',7500,.3,146,80) / INSERT INTO employees values(161,'Sarath','Sewall','SSEWALL','011.44.1345.529268',to_date('03-NOV-98','dd-mon-RR'),'SA_REP',7000,.25,146,80) / INSERT INTO employees values(162,'Clara','Vishney','CVISHNEY','011.44.1346.129268',to_date('11-NOV-97','dd-mon-RR'),'SA_REP',10500,.25,147,80) / INSERT INTO employees values(163,'Danielle','Greene','DGREENE','011.44.1346.229268',to_date('19-MAR-99','dd-mon-RR'),'SA_REP',9500,.15,147,80) / INSERT INTO employees values(164,'Mattea','Marvins','MMARVINS','011.44.1346.329268',to_date('24-JAN-00','dd-mon-RR'),'SA_REP',7200,.1,147,80) / INSERT INTO employees values(165,'David','Lee','DLEE','011.44.1346.529268',to_date('23-FEB-00','dd-mon-RR'),'SA_REP',6800,.1,147,80) / INSERT INTO employees values(166,'Sundar','Ande','SANDE','011.44.1346.629268',to_date('24-MAR-00','dd-mon-RR'),'SA_REP',6400,.1,147,80) / INSERT INTO employees values(167,'Amit','Banda','ABANDA','011.44.1346.729268',to_date('21-APR-00','dd-mon-RR'),'SA_REP',6200,.1,147,80) / INSERT INTO employees values(168,'Lisa','Ozer','LOZER','011.44.1343.929268',to_date('11-MAR-97','dd-mon-RR'),'SA_REP',11500,.25,148,80) / INSERT INTO employees values(169,'Harrison','Bloom','HBLOOM','011.44.1343.829268',to_date('23-MAR-98','dd-mon-RR'),'SA_REP',10000,.2,148,80) / INSERT INTO employees values(170,'Tayler','Fox','TFOX','011.44.1343.729268',to_date('24-JAN-98','dd-mon-RR'),'SA_REP',9600,.2,148,80) / INSERT INTO employees values(171,'William','Smith','WSMITH','011.44.1343.629268',to_date('23-FEB-99','dd-mon-RR'),'SA_REP',7400,.15,148,80) / INSERT INTO employees values(172,'Elizabeth','Bates','EBATES','011.44.1343.529268',to_date('24-MAR-99','dd-mon-RR'),'SA_REP',7300,.15,148,80) / INSERT INTO employees values(173,'Sundita','Kumar','SKUMAR','011.44.1343.329268',to_date('21-APR-00','dd-mon-RR'),'SA_REP',6100,.1,148,80) / INSERT INTO employees values(174,'Ellen','Abel','EABEL','011.44.1644.429267',to_date('11-MAY-96','dd-mon-RR'),'SA_REP',11000,.3,149,80) / INSERT INTO employees values(175,'Alyssa','Hutton','AHUTTON','011.44.1644.429266',to_date('19-MAR-97','dd-mon-RR'),'SA_REP',8800,.25,149,80) / INSERT INTO employees values(176,'Jonathon','Taylor','JTAYLOR','011.44.1644.429265',to_date('24-MAR-98','dd-mon-RR'),'SA_REP',8600,.2,149,80) / INSERT INTO employees values(177,'Jack','Livingston','JLIVINGS','011.44.1644.429264',to_date('23-APR-98','dd-mon-RR'),'SA_REP',8400,.2,149,80) / INSERT INTO employees values(178,'Kimberely','Grant','KGRANT','011.44.1644.429263',to_date('24-MAY-99','dd-mon-RR'),'SA_REP',7000,.15,149,Null) / INSERT INTO employees values(179,'Charles','Johnson','CJOHNSON','011.44.1644.429262',to_date('04-JAN-00','dd-mon-RR'),'SA_REP',6200,.1,149,80) / INSERT INTO employees values(180,'Winston','Taylor','WTAYLOR','650.507.9876',to_date('24-JAN-98','dd-mon-RR'),'SH_CLERK',3200,Null,120,50) / INSERT INTO employees values(181,'Jean','Fleaur','JFLEAUR','650.507.9877',to_date('23-FEB-98','dd-mon-RR'),'SH_CLERK',3100,Null,120,50) / INSERT INTO employees values(182,'Martha','Sullivan','MSULLIVA','650.507.9878',to_date('21-JUN-99','dd-mon-RR'),'SH_CLERK',2500,Null,120,50) / INSERT INTO employees values(183,'Girard','Geoni','GGEONI','650.507.9879',to_date('03-FEB-00','dd-mon-RR'),'SH_CLERK',2800,Null,120,50) / INSERT INTO employees values(184,'Nandita','Sarchand','NSARCHAN','650.509.1876',to_date('27-JAN-96','dd-mon-RR'),'SH_CLERK',4200,Null,121,50) / INSERT INTO employees values(185,'Alexis','Bull','ABULL','650.509.2876',to_date('20-FEB-97','dd-mon-RR'),'SH_CLERK',4100,Null,121,50) / INSERT INTO employees values(186,'Julia','Dellinger','JDELLING','650.509.3876',to_date('24-JUN-98','dd-mon-RR'),'SH_CLERK',3400,Null,121,50) / INSERT INTO employees values(187,'Anthony','Cabrio','ACABRIO','650.509.4876',to_date('07-FEB-99','dd-mon-RR'),'SH_CLERK',3000,Null,121,50) / INSERT INTO employees values(188,'Kelly','Chung','KCHUNG','650.505.1876',to_date('14-JUN-97','dd-mon-RR'),'SH_CLERK',3800,Null,122,50) / INSERT INTO employees values(189,'Jennifer','Dilly','JDILLY','650.505.2876',to_date('13-AUG-97','dd-mon-RR'),'SH_CLERK',3600,Null,122,50) / INSERT INTO employees values(190,'Timothy','Gates','TGATES','650.505.3876',to_date('11-JUL-98','dd-mon-RR'),'SH_CLERK',2900,Null,122,50) / INSERT INTO employees values(191,'Randall','Perkins','RPERKINS','650.505.4876',to_date('19-DEC-99','dd-mon-RR'),'SH_CLERK',2500,Null,122,50) / INSERT INTO employees values(192,'Sarah','Bell','SBELL','650.501.1876',to_date('04-FEB-96','dd-mon-RR'),'SH_CLERK',4000,Null,123,50) / INSERT INTO employees values(193,'Britney','Everett','BEVERETT','650.501.2876',to_date('03-MAR-97','dd-mon-RR'),'SH_CLERK',3900,Null,123,50) / INSERT INTO employees values(194,'Samuel','McCain','SMCCAIN','650.501.3876',to_date('01-JUL-98','dd-mon-RR'),'SH_CLERK',3200,Null,123,50) / INSERT INTO employees values(195,'Vance','Jones','VJONES','650.501.4876',to_date('17-MAR-99','dd-mon-RR'),'SH_CLERK',2800,Null,123,50) / INSERT INTO employees values(196,'Alana','Walsh','AWALSH','650.507.9811',to_date('24-APR-98','dd-mon-RR'),'SH_CLERK',3100,Null,124,50) / INSERT INTO employees values(197,'Kevin','Feeney','KFEENEY','650.507.9822',to_date('23-MAY-98','dd-mon-RR'),'SH_CLERK',3000,Null,124,50) / INSERT INTO employees values(198,'Donald','OConnell','DOCONNEL','650.507.9833',to_date('21-JUN-99','dd-mon-RR'),'SH_CLERK',2600,Null,124,50) / INSERT INTO employees values(199,'Douglas','Grant','DGRANT','650.507.9844',to_date('13-JAN-00','dd-mon-RR'),'SH_CLERK',2600,Null,124,50) / INSERT INTO employees values(200,'Jennifer','Whalen','JWHALEN','515.123.4444',to_date('17-SEP-87','dd-mon-RR'),'AD_ASST',4400,Null,101,10) / INSERT INTO employees values(201,'Michael','Hartstein','MHARTSTE','515.123.5555',to_date('17-FEB-96','dd-mon-RR'),'MK_MAN',13000,Null,100,20) / INSERT INTO employees values(202,'Pat','Fay','PFAY','603.123.6666',to_date('17-AUG-97','dd-mon-RR'),'MK_REP',6000,Null,201,20) / INSERT INTO employees values(203,'Susan','Mavris','SMAVRIS','515.123.7777',to_date('07-JUN-94','dd-mon-RR'),'HR_REP',6500,Null,101,40) / INSERT INTO employees values(204,'Hermann','Baer','HBAER','515.123.8888',to_date('07-JUN-94','dd-mon-RR'),'PR_REP',10000,Null,101,70) / INSERT INTO employees values(205,'Shelley','Higgins','SHIGGINS','515.123.8080',to_date('07-JUN-94','dd-mon-RR'),'AC_MGR',12000,Null,101,110) / INSERT INTO employees values(206,'William','Gietz','WGIETZ','515.123.8181',to_date('07-JUN-94','dd-mon-RR'),'AC_ACCOUNT',8300,Null,205,110) / --inserting into job_history table INSERT INTO job_history values(102,to_date('13-JAN-93','dd-mon-RR'),to_date('24-JUL-98','dd-mon-RR'),'IT_PROG','60') / INSERT INTO job_history values(101,to_date('21-SEP-89','dd-mon-RR'),to_date('27-OCT-93','dd-mon-RR'),'AC_ACCOUNT','110') / INSERT INTO job_history values(101,to_date('28-OCT-93','dd-mon-RR'),to_date('15-MAR-97','dd-mon-RR'),'AC_MGR','110') / INSERT INTO job_history values(201,to_date('17-FEB-96','dd-mon-RR'),to_date('19-DEC-99','dd-mon-RR'),'MK_REP','20') / INSERT INTO job_history values(114,to_date('24-MAR-98','dd-mon-RR'),to_date('31-DEC-99','dd-mon-RR'),'ST_CLERK','50') / INSERT INTO job_history values(122,to_date('01-JAN-99','dd-mon-RR'),to_date('31-DEC-99','dd-mon-RR'),'ST_CLERK','50') / INSERT INTO job_history values(200,to_date('17-SEP-87','dd-mon-RR'),to_date('17-JUN-93','dd-mon-RR'),'AD_ASST','90') / INSERT INTO job_history values(176,to_date('24-MAR-98','dd-mon-RR'),to_date('31-DEC-98','dd-mon-RR'),'SA_REP','80') / INSERT INTO job_history values(176,to_date('01-JAN-99','dd-mon-RR'),to_date('31-DEC-99','dd-mon-RR'),'SA_MAN','80') / INSERT INTO job_history values(200,to_date('01-JUL-94','dd-mon-RR'),to_date('31-DEC-98','dd-mon-RR'),'AC_ACCOUNT','90') / -- INSERTING into SAL_GRADE Insert into SAL_GRADE (GRADE,MIN_SAL,MAX_SAL) values ('A',1000,2499.99) / Insert into SAL_GRADE (GRADE,MIN_SAL,MAX_SAL) values ('B',2500,4999.99) / Insert into SAL_GRADE (GRADE,MIN_SAL,MAX_SAL) values ('C',5000,7499.99) / Insert into SAL_GRADE (GRADE,MIN_SAL,MAX_SAL) values ('D',7500,9999.99) / Insert into SAL_GRADE (GRADE,MIN_SAL,MAX_SAL) values ('E',10000,14999.99) / Insert into SAL_GRADE (GRADE,MIN_SAL,MAX_SAL) values ('F',15000,19999.99) / --inserting data into salary_raise INSERT INTO salary_raise VALUES(126,121.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(127,108,'01-JUL-07') / INSERT INTO salary_raise VALUES(128,99,'01-JUL-07') / INSERT INTO salary_raise VALUES(129,148.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(130,126,'01-JUL-07') / INSERT INTO salary_raise VALUES(131,112.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(132,94.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(133,148.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(134,130.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(135,108,'01-JUL-07') / INSERT INTO salary_raise VALUES(136,99,'01-JUL-07') / INSERT INTO salary_raise VALUES(137,162,'01-JUL-07') / INSERT INTO salary_raise VALUES(138,144,'01-JUL-07') / INSERT INTO salary_raise VALUES(139,121.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(140,112.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(141,157.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(142,139.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(143,117,'01-JUL-07') / INSERT INTO salary_raise VALUES(144,112.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(145,630,'01-JUL-07') / INSERT INTO salary_raise VALUES(146,607.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(147,540,'01-JUL-07') / INSERT INTO salary_raise VALUES(148,495,'01-JUL-07') / INSERT INTO salary_raise VALUES(149,472.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(150,450,'01-JUL-07') / INSERT INTO salary_raise VALUES(151,427.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(152,405,'01-JUL-07') / INSERT INTO salary_raise VALUES(153,360,'01-JUL-07') / INSERT INTO salary_raise VALUES(154,337.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(155,315,'01-JUL-07') / INSERT INTO salary_raise VALUES(156,450,'01-JUL-07') / INSERT INTO salary_raise VALUES(157,427.5,'01-JUL-07') / INSERT INTO salary_raise VALUES(158,405,'01-JUL-07') / INSERT INTO salary_raise VALUES(159,360,'01-JUL-07') /