转：HR schema

REM ********************************************************************
REM Create the EMPLOYEES table to hold the employee personnel
REM information for the company.
REM HR.EMPLOYEES has a self referencing foreign key to this table.

Prompt ****** Creating EMPLOYEES table ....

CREATE TABLE employees
( employee_id NUMBER(6)
,first_name VARCHAR2(20)
,last_name VARCHAR2(25)
CONSTRAINT emp_last_name_nn NOT NULL
,email VARCHAR2(25)
CONSTRAINT emp_email_nn NOT NULL
,phone_number VARCHAR2(20)
,hire_date DATE
CONSTRAINT emp_hire_date_nn NOT NULL
,job_id VARCHAR2(10)
CONSTRAINT emp_job_nn NOT NULL
,salary NUMBER(8,2)
,commission_pct NUMBER(2,department_id NUMBER(4)
,CONSTRAINT emp_salary_min
CHECK (salary > 0)
,CONSTRAINT emp_email_uk
UNIQUE (email)
) ;

CREATE UNIQUE INDEX emp_emp_id_pk
ON employees (employee_id) ;

ALTER TABLE employees
ADD ( CONSTRAINT emp_emp_id_pk
PRIMARY KEY (employee_id)
,CONSTRAINT emp_dept_fk
FOREIGN KEY (department_id)
REFERENCES departments
,CONSTRAINT emp_job_fk
FOREIGN KEY (job_id)
REFERENCES jobs (job_id)
,CONSTRAINT emp_manager_fk
FOREIGN KEY (manager_id)
REFERENCES employees
) ;

ALTER TABLE departments
ADD ( CONSTRAINT dept_mgr_fk
FOREIGN KEY (manager_id)
REFERENCES employees (employee_id)
) ;

Rem Useful for any subsequent addition of rows to employees table
Rem Starts with 207

CREATE SEQUENCE employees_seq
START WITH 207
INCREMENT BY 1
NOCACHE
NOCYCLE;

REM ********************************************************************
REM Create the JOB_HISTORY table to hold the history of jobs that
REM employees have held in the past.
REM HR.JOBS,HR_DEPARTMENTS,and HR.EMPLOYEES have a foreign key to this table.

Prompt ****** Creating JOB_HISTORY table ....

CREATE TABLE job_history
( employee_id NUMBER(6)
CONSTRAINT jhist_employee_nn NOT NULL
,start_date DATE
CONSTRAINT jhist_start_date_nn NOT NULL
,end_date DATE
CONSTRAINT jhist_end_date_nn NOT NULL
,job_id VARCHAR2(10)
CONSTRAINT jhist_job_nn NOT NULL
,CONSTRAINT jhist_date_interval
CHECK (end_date > start_date)
) ;

CREATE UNIQUE INDEX jhist_emp_id_st_date_pk
ON job_history (employee_id,start_date) ;

ALTER TABLE job_history
ADD ( CONSTRAINT jhist_emp_id_st_date_pk
PRIMARY KEY (employee_id,start_date)
,CONSTRAINT jhist_job_fk
FOREIGN KEY (job_id)
REFERENCES jobs
,CONSTRAINT jhist_emp_fk
FOREIGN KEY (employee_id)
REFERENCES employees
,CONSTRAINT jhist_dept_fk
FOREIGN KEY (department_id)
REFERENCES departments
) ;

REM ********************************************************************
REM Create the EMP_DETAILS_VIEW that joins the employees,jobs,
REM departments,countries,and locations table to provide details
REM about employees.

Prompt ****** Creating EMP_DETAILS_VIEW view ...

CREATE OR REPLACE VIEW emp_details_view
(employee_id,
job_id,
manager_id,
department_id,
location_id,
country_id,
first_name,
last_name,
salary,
commission_pct,
department_name,
job_title,
city,
state_province,
country_name,
region_name)
AS SELECT
e.employee_id,
e.job_id,
e.manager_id,
e.department_id,
d.location_id,
l.country_id,
e.first_name,
e.last_name,
e.salary,
e.commission_pct,
d.department_name,
j.job_title,
l.city,
l.state_province,
c.country_name,
r.region_name
FROM
employees e,
departments d,
jobs j,
locations l,
countries c,
regions r
WHERE e.department_id = d.department_id
AND d.location_id = l.location_id
AND l.country_id = c.country_id
AND c.region_id = r.region_id
AND j.job_id = e.job_id
WITH READ ONLY;

COMMIT;
Back to Top

Back to Top

?

###insert?

remrem Header: hr_popul.sql 09-jan-01remrem Copyright (c) 2001 Oracle Corporation. All rights reserved.remrem Owner : ahunoldremrem NAMErem hr_popul.sql - Populate script for HR schemaremrem DESCRIPTONremremrem NOTESrem There is a circular foreign key reference between rem EMPLOYESS and DEPARTMENTS. That‘s why we disablerem the FK constraints hereremrem CREATEDrem Nancy Greenberg,Nagavalli Pataballa - 06/01/00remrem MODIFIED (MM/DD/YY)rem ahunold 03/07/01 - small data errors correctedrem - Modified region values of countries tablerem - Replaced ID sequence values for employeesrem and departments tables with numbersrem - Moved create sequence statements to hr_crerem - Removed dn values for employees andrem departments tablesrem - Removed currency columns values fromrem countries tablerem ngreenbe - Updated employee 178 for no departmentrem pnathan - Insert new rows to job_history tablerem ahunold 02/20/01 - NLS_LANGUAGE,replacing non Americanrem ahunold 01/09/01 - checkin ADErem Chaitanya Koratamaddi - 02/05/06SET VERIFY OFFALTER SESSION SET NLS_LANGUAGE=American; REM ***************************insert data into the REGIONS tablePrompt ****** Populating REGIONS table ....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‘ );REM ***************************insert data into the COUNTRIES tablePrompt ****** Populating COUNTIRES table ....INSERT INTO countries VALUES ( ‘IT‘,‘Italy‘,1 );INSERT INTO countries VALUES ( ‘JP‘,‘Japan‘,3 );INSERT INTO countries VALUES ( ‘US‘,‘United States of America‘,2 );INSERT INTO countries VALUES ( ‘CA‘,‘Canada‘,2 );INSERT INTO countries VALUES ( ‘CN‘,‘China‘,3 );INSERT INTO countries VALUES ( ‘IN‘,‘India‘,3 );INSERT INTO countries VALUES ( ‘AU‘,‘Australia‘,3 );INSERT INTO countries VALUES ( ‘ZW‘,‘Zimbabwe‘,4 );INSERT INTO countries VALUES ( ‘SG‘,‘Singapore‘,3 );INSERT INTO countries VALUES ( ‘UK‘,‘United Kingdom‘,1 );INSERT INTO countries VALUES ( ‘FR‘,‘France‘,1 );INSERT INTO countries VALUES ( ‘DE‘,‘Germany‘,1 );INSERT INTO countries VALUES ( ‘ZM‘,‘Zambia‘,4 );INSERT INTO countries VALUES ( ‘EG‘,‘Egypt‘,4 );INSERT INTO countries VALUES ( ‘BR‘,‘Brazil‘,2 );INSERT INTO countries VALUES ( ‘CH‘,‘Switzerland‘,1 );INSERT INTO countries VALUES ( ‘NL‘,‘Netherlands‘,1 );INSERT INTO countries VALUES ( ‘MX‘,‘Mexico‘,2 );INSERT INTO countries VALUES ( ‘KW‘,‘Kuwait‘,4 );INSERT INTO countries VALUES ( ‘IL‘,‘Israel‘,4 );INSERT INTO countries VALUES ( ‘DK‘,‘Denmark‘,1 );INSERT INTO countries VALUES ( ‘HK‘,‘HongKong‘,3 );INSERT INTO countries VALUES ( ‘NG‘,‘Nigeria‘,4 );INSERT INTO countries VALUES ( ‘AR‘,‘Argentina‘,2 );INSERT INTO countries VALUES ( ‘BE‘,‘Belgium‘,1 );REM ***************************insert data into the LOCATIONS tablePrompt ****** Populating LOCATIONS table ....INSERT INTO locations VALUES ( 1000,‘1297 Via Cola di Rie‘,‘00989‘,‘Roma‘,NULL,‘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‘,‘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‘,‘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‘,‘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‘,‘NL‘ );INSERT INTO locations VALUES ( 3200,‘Mariano Escobedo 9991‘,‘11932‘,‘Mexico City‘,‘Distrito Federal,‘,‘MX‘ );REM ****************************insert data into the DEPARTMENTS tablePrompt ****** Populating DEPARTMENTS table ....REM disable integrity constraint to EMPLOYEES to load dataALTER TABLE departments DISABLE CONSTRAINT dept_mgr_fk;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‘,1700 );INSERT INTO departments VALUES ( 130,‘Corporate Tax‘,1700 );INSERT INTO departments VALUES ( 140,‘Control And Credit‘,1700 );INSERT INTO departments VALUES ( 150,‘Shareholder Services‘,1700 );INSERT INTO departments VALUES ( 160,‘Benefits‘,1700 );INSERT INTO departments VALUES ( 170,‘Manufacturing‘,1700 );INSERT INTO departments VALUES ( 180,‘Construction‘,1700 );INSERT INTO departments VALUES ( 190,‘Contracting‘,1700 );INSERT INTO departments VALUES ( 200,‘Operations‘,1700 );INSERT INTO departments VALUES ( 210,‘IT Support‘,1700 );INSERT INTO departments VALUES ( 220,‘NOC‘,1700 );INSERT INTO departments VALUES ( 230,‘IT Helpdesk‘,1700 );INSERT INTO departments VALUES ( 240,‘Government Sales‘,1700 );INSERT INTO departments VALUES ( 250,‘Retail Sales‘,1700 );INSERT INTO departments VALUES ( 260,‘Recruiting‘,1700 );INSERT INTO departments VALUES ( 270,‘Payroll‘,1700 );REM ***************************insert data into the JOBS tablePrompt ****** Populating JOBS table ....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‘,16000 );INSERT INTO jobs VALUES ( ‘AC_ACCOUNT‘,‘Public Accountant‘,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‘,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‘,9000 );INSERT INTO jobs VALUES ( ‘HR_REP‘,‘Human Resources Representative‘,9000 );INSERT INTO jobs VALUES ( ‘PR_REP‘,‘Public Relations Representative‘,4500,10500 );REM ***************************insert data into the EMPLOYEES tablePrompt ****** Populating EMPLOYEES table ....INSERT INTO employees VALUES ( 100,‘Steven‘,‘King‘,‘SKING‘,‘515.123.4567‘,TO_DATE(‘17-JUN-1987‘,‘dd-MON-yyyy‘),‘AD_PRES‘,24000,90 );INSERT INTO employees VALUES ( 101,‘Neena‘,‘Kochhar‘,‘NKOCHHAR‘,‘515.123.4568‘,TO_DATE(‘21-SEP-1989‘,‘AD_VP‘,17000,90 );INSERT INTO employees VALUES ( 102,‘Lex‘,‘De Haan‘,‘LDEHAAN‘,‘515.123.4569‘,TO_DATE(‘13-JAN-1993‘,90 );INSERT INTO employees VALUES ( 103,‘Alexander‘,‘Hunold‘,‘AHUNOLD‘,‘590.423.4567‘,TO_DATE(‘03-JAN-1990‘,‘IT_PROG‘,102,60 );INSERT INTO employees VALUES ( 104,‘Bruce‘,‘Ernst‘,‘BERNST‘,‘590.423.4568‘,TO_DATE(‘21-MAY-1991‘,60 );INSERT INTO employees VALUES ( 105,‘David‘,‘Austin‘,‘DAUSTIN‘,‘590.423.4569‘,TO_DATE(‘25-JUN-1997‘,4800,60 );INSERT INTO employees VALUES ( 106,‘Valli‘,‘Pataballa‘,‘VPATABAL‘,‘590.423.4560‘,TO_DATE(‘05-FEB-1998‘,60 );INSERT INTO employees VALUES ( 107,‘Diana‘,‘Lorentz‘,‘DLORENTZ‘,‘590.423.5567‘,TO_DATE(‘07-FEB-1999‘,60 );INSERT INTO employees VALUES ( 108,‘Nancy‘,‘Greenberg‘,‘NGREENBE‘,‘515.124.4569‘,TO_DATE(‘17-AUG-1994‘,‘FI_MGR‘,12000,101,100 );INSERT INTO employees VALUES ( 109,‘Daniel‘,‘Faviet‘,‘DFAVIET‘,‘515.124.4169‘,TO_DATE(‘16-AUG-1994‘,‘FI_ACCOUNT‘,100 );INSERT INTO employees VALUES ( 110,‘John‘,‘Chen‘,‘JCHEN‘,‘515.124.4269‘,TO_DATE(‘28-SEP-1997‘,100 );INSERT INTO employees VALUES ( 111,‘Ismael‘,‘Sciarra‘,‘ISCIARRA‘,‘515.124.4369‘,TO_DATE(‘30-SEP-1997‘,7700,100 );INSERT INTO employees VALUES ( 112,‘Jose Manuel‘,‘Urman‘,‘JMURMAN‘,‘515.124.4469‘,TO_DATE(‘07-MAR-1998‘,7800,100 );INSERT INTO employees VALUES ( 113,‘Luis‘,‘Popp‘,‘LPOPP‘,‘515.124.4567‘,TO_DATE(‘07-DEC-1999‘,6900,100 );INSERT INTO employees VALUES ( 114,‘Den‘,‘Raphaely‘,‘DRAPHEAL‘,‘515.127.4561‘,TO_DATE(‘07-DEC-1994‘,‘PU_MAN‘,11000,30 );INSERT INTO employees VALUES ( 115,‘Khoo‘,‘AKHOO‘,‘515.127.4562‘,TO_DATE(‘18-MAY-1995‘,‘PU_CLERK‘,3100,30 );INSERT INTO employees VALUES ( 116,‘Shelli‘,‘Baida‘,‘SBAIDA‘,‘515.127.4563‘,TO_DATE(‘24-DEC-1997‘,2900,30 );INSERT INTO employees VALUES ( 117,‘Sigal‘,‘Tobias‘,‘STOBIAS‘,‘515.127.4564‘,TO_DATE(‘24-JUL-1997‘,2800,30 );INSERT INTO employees VALUES ( 118,‘Guy‘,‘Himuro‘,‘GHIMURO‘,‘515.127.4565‘,TO_DATE(‘15-NOV-1998‘,2600,30 );INSERT INTO employees VALUES ( 119,‘Karen‘,‘Colmenares‘,‘KCOLMENA‘,‘515.127.4566‘,TO_DATE(‘10-AUG-1999‘,30 );INSERT INTO employees VALUES ( 120,‘Matthew‘,‘Weiss‘,‘MWEISS‘,‘650.123.1234‘,TO_DATE(‘18-JUL-1996‘,‘ST_MAN‘,50 );INSERT INTO employees VALUES ( 121,‘Adam‘,‘Fripp‘,‘AFRIPP‘,‘650.123.2234‘,TO_DATE(‘10-APR-1997‘,50 );INSERT INTO employees VALUES ( 122,‘Payam‘,‘Kaufling‘,‘PKAUFLIN‘,‘650.123.3234‘,TO_DATE(‘01-MAY-1995‘,7900,50 );INSERT INTO employees VALUES ( 123,‘Shanta‘,‘Vollman‘,‘SVOLLMAN‘,‘650.123.4234‘,TO_DATE(‘10-OCT-1997‘,6500,50 );INSERT INTO employees VALUES ( 124,‘Kevin‘,‘Mourgos‘,‘KMOURGOS‘,‘650.123.5234‘,TO_DATE(‘16-NOV-1999‘,5800,50 );INSERT INTO employees VALUES ( 125,‘Julia‘,‘Nayer‘,‘JNAYER‘,‘650.124.1214‘,TO_DATE(‘16-JUL-1997‘,‘ST_CLERK‘,3200,120,50 );INSERT INTO employees VALUES ( 126,‘Irene‘,‘Mikkilineni‘,‘IMIKKILI‘,‘650.124.1224‘,TO_DATE(‘28-SEP-1998‘,2700,50 );INSERT INTO employees VALUES ( 127,‘James‘,‘Landry‘,‘JLANDRY‘,‘650.124.1334‘,TO_DATE(‘14-JAN-1999‘,2400,50 );INSERT INTO employees VALUES ( 128,‘Markle‘,‘SMARKLE‘,‘650.124.1434‘,TO_DATE(‘08-MAR-2000‘,2200,50 );INSERT INTO employees VALUES ( 129,‘Laura‘,‘Bissot‘,‘LBISSOT‘,‘650.124.5234‘,TO_DATE(‘20-AUG-1997‘,3300,50 );INSERT INTO employees VALUES ( 130,‘Mozhe‘,‘Atkinson‘,‘MATKINSO‘,‘650.124.6234‘,TO_DATE(‘30-OCT-1997‘,50 );INSERT INTO employees VALUES ( 131,‘Marlow‘,‘JAMRLOW‘,‘650.124.7234‘,TO_DATE(‘16-FEB-1997‘,50 );INSERT INTO employees VALUES ( 132,‘TJ‘,‘Olson‘,‘TJOLSON‘,‘650.124.8234‘,TO_DATE(‘10-APR-1999‘,2100,50 );INSERT INTO employees VALUES ( 133,‘Jason‘,‘Mallin‘,‘JMALLIN‘,‘650.127.1934‘,TO_DATE(‘14-JUN-1996‘,122,50 );INSERT INTO employees VALUES ( 134,‘Michael‘,‘Rogers‘,‘MROGERS‘,‘650.127.1834‘,TO_DATE(‘26-AUG-1998‘,50 );INSERT INTO employees VALUES ( 135,‘Ki‘,‘Gee‘,‘KGEE‘,‘650.127.1734‘,TO_DATE(‘12-DEC-1999‘,50 );INSERT INTO employees VALUES ( 136,‘Hazel‘,‘Philtanker‘,‘HPHILTAN‘,‘650.127.1634‘,TO_DATE(‘06-FEB-2000‘,50 );INSERT INTO employees VALUES ( 137,‘Renske‘,‘Ladwig‘,‘RLADWIG‘,‘650.121.1234‘,TO_DATE(‘14-JUL-1995‘,3600,123,50 );INSERT INTO employees VALUES ( 138,‘Stephen‘,‘Stiles‘,‘SSTILES‘,‘650.121.2034‘,TO_DATE(‘26-OCT-1997‘,50 );INSERT INTO employees VALUES ( 139,‘SEO‘,‘JSEO‘,‘650.121.2019‘,TO_DATE(‘12-FEB-1998‘,50 );INSERT INTO employees VALUES ( 140,‘Joshua‘,‘Patel‘,‘JPATEL‘,‘650.121.1834‘,TO_DATE(‘06-APR-1998‘,50 );INSERT INTO employees VALUES ( 141,‘Trenna‘,‘Rajs‘,‘TRAJS‘,‘650.121.8009‘,TO_DATE(‘17-OCT-1995‘,3500,124,50 );INSERT INTO employees VALUES ( 142,‘Curtis‘,‘Davies‘,‘CDAVIES‘,‘650.121.2994‘,TO_DATE(‘29-JAN-1997‘,50 );INSERT INTO employees VALUES ( 143,‘Randall‘,‘Matos‘,‘RMATOS‘,‘650.121.2874‘,TO_DATE(‘15-MAR-1998‘,50 );INSERT INTO employees VALUES ( 144,‘Peter‘,‘Vargas‘,‘PVARGAS‘,‘650.121.2004‘,TO_DATE(‘09-JUL-1998‘,50 );INSERT INTO employees VALUES ( 145,‘Russell‘,‘JRUSSEL‘,‘011.44.1344.429268‘,TO_DATE(‘01-OCT-1996‘,‘SA_MAN‘,14000,.4,80 );INSERT INTO employees VALUES ( 146,‘Partners‘,‘KPARTNER‘,‘011.44.1344.467268‘,TO_DATE(‘05-JAN-1997‘,13500,.3,80 );INSERT INTO employees VALUES ( 147,‘Alberto‘,‘Errazuriz‘,‘AERRAZUR‘,‘011.44.1344.429278‘,TO_DATE(‘10-MAR-1997‘,80 );INSERT INTO employees VALUES ( 148,‘Gerald‘,‘Cambrault‘,‘GCAMBRAU‘,‘011.44.1344.619268‘,TO_DATE(‘15-OCT-1999‘,80 );INSERT INTO employees VALUES ( 149,‘Eleni‘,‘Zlotkey‘,‘EZLOTKEY‘,‘011.44.1344.429018‘,TO_DATE(‘29-JAN-2000‘,10500,.2,80 );INSERT INTO employees VALUES ( 150,‘Tucker‘,‘PTUCKER‘,‘011.44.1344.129268‘,TO_DATE(‘30-JAN-1997‘,‘SA_REP‘,80 );INSERT INTO employees VALUES ( 151,‘Bernstein‘,‘DBERNSTE‘,‘011.44.1344.345268‘,TO_DATE(‘24-MAR-1997‘,9500,.25,80 );INSERT INTO employees VALUES ( 152,‘Hall‘,‘PHALL‘,‘011.44.1344.478968‘,80 );INSERT INTO employees VALUES ( 153,‘Christopher‘,‘Olsen‘,‘COLSEN‘,‘011.44.1344.498718‘,TO_DATE(‘30-MAR-1998‘,80 );INSERT INTO employees VALUES ( 154,‘Nanette‘,‘NCAMBRAU‘,‘011.44.1344.987668‘,TO_DATE(‘09-DEC-1998‘,7500,80 );INSERT INTO employees VALUES ( 155,‘Oliver‘,‘Tuvault‘,‘OTUVAULT‘,‘011.44.1344.486508‘,TO_DATE(‘23-NOV-1999‘,7000,.15,80 );INSERT INTO employees VALUES ( 156,‘Janette‘,‘JKING‘,‘011.44.1345.429268‘,TO_DATE(‘30-JAN-1996‘,.35,146,80 );INSERT INTO employees VALUES ( 157,‘Patrick‘,‘Sully‘,‘PSULLY‘,‘011.44.1345.929268‘,TO_DATE(‘04-MAR-1996‘,80 );INSERT INTO employees VALUES ( 158,‘Allan‘,‘McEwen‘,‘AMCEWEN‘,‘011.44.1345.829268‘,TO_DATE(‘01-AUG-1996‘,80 );INSERT INTO employees VALUES ( 159,‘Lindsey‘,‘Smith‘,‘LSMITH‘,‘011.44.1345.729268‘,80 );INSERT INTO employees VALUES ( 160,‘Louise‘,‘Doran‘,‘LDORAN‘,‘011.44.1345.629268‘,TO_DATE(‘15-DEC-1997‘,80 );INSERT INTO employees VALUES ( 161,‘Sarath‘,‘Sewall‘,‘SSEWALL‘,‘011.44.1345.529268‘,TO_DATE(‘03-NOV-1998‘,80 );INSERT INTO employees VALUES ( 162,‘Clara‘,‘Vishney‘,‘CVISHNEY‘,‘011.44.1346.129268‘,TO_DATE(‘11-NOV-1997‘,147,80 );INSERT INTO employees VALUES ( 163,‘Danielle‘,‘Greene‘,‘DGREENE‘,‘011.44.1346.229268‘,TO_DATE(‘19-MAR-1999‘,80 );INSERT INTO employees VALUES ( 164,‘Mattea‘,‘Marvins‘,‘MMARVINS‘,‘011.44.1346.329268‘,TO_DATE(‘24-JAN-2000‘,7200,.10,80 );INSERT INTO employees VALUES ( 165,‘Lee‘,‘DLEE‘,‘011.44.1346.529268‘,TO_DATE(‘23-FEB-2000‘,6800,.1,80 );INSERT INTO employees VALUES ( 166,‘Sundar‘,‘Ande‘,‘SANDE‘,‘011.44.1346.629268‘,TO_DATE(‘24-MAR-2000‘,6400,80 );INSERT INTO employees VALUES ( 167,‘Amit‘,‘Banda‘,‘ABANDA‘,‘011.44.1346.729268‘,TO_DATE(‘21-APR-2000‘,6200,80 );INSERT INTO employees VALUES ( 168,‘Lisa‘,‘Ozer‘,‘LOZER‘,‘011.44.1343.929268‘,TO_DATE(‘11-MAR-1997‘,11500,148,80 );INSERT INTO employees VALUES ( 169,‘Harrison‘,‘Bloom‘,‘HBLOOM‘,‘011.44.1343.829268‘,TO_DATE(‘23-MAR-1998‘,.20,80 );INSERT INTO employees VALUES ( 170,‘Tayler‘,‘Fox‘,‘TFOX‘,‘011.44.1343.729268‘,TO_DATE(‘24-JAN-1998‘,9600,80 );INSERT INTO employees VALUES ( 171,‘William‘,‘WSMITH‘,‘011.44.1343.629268‘,TO_DATE(‘23-FEB-1999‘,7400,80 );INSERT INTO employees VALUES ( 172,‘Elizabeth‘,‘Bates‘,‘EBATES‘,‘011.44.1343.529268‘,TO_DATE(‘24-MAR-1999‘,7300,80 );INSERT INTO employees VALUES ( 173,‘Sundita‘,‘Kumar‘,‘SKUMAR‘,‘011.44.1343.329268‘,6100,80 );INSERT INTO employees VALUES ( 174,‘Ellen‘,‘Abel‘,‘EABEL‘,‘011.44.1644.429267‘,TO_DATE(‘11-MAY-1996‘,.30,149,80 );INSERT INTO employees VALUES ( 175,‘Alyssa‘,‘Hutton‘,‘AHUTTON‘,‘011.44.1644.429266‘,TO_DATE(‘19-MAR-1997‘,8800,80 );INSERT INTO employees VALUES ( 176,‘Jonathon‘,‘Taylor‘,‘JTAYLOR‘,‘011.44.1644.429265‘,TO_DATE(‘24-MAR-1998‘,8600,80 );INSERT INTO employees VALUES ( 177,‘Jack‘,‘Livingston‘,‘JLIVINGS‘,‘011.44.1644.429264‘,TO_DATE(‘23-APR-1998‘,8400,80 );INSERT INTO employees VALUES ( 178,‘Kimberely‘,‘Grant‘,‘KGRANT‘,‘011.44.1644.429263‘,TO_DATE(‘24-MAY-1999‘,NULL );INSERT INTO employees VALUES ( 179,‘Charles‘,‘Johnson‘,‘CJOHNSON‘,‘011.44.1644.429262‘,TO_DATE(‘04-JAN-2000‘,80 );INSERT INTO employees VALUES ( 180,‘Winston‘,‘WTAYLOR‘,‘650.507.9876‘,‘SH_CLERK‘,50 );INSERT INTO employees VALUES ( 181,‘Jean‘,‘Fleaur‘,‘JFLEAUR‘,‘650.507.9877‘,TO_DATE(‘23-FEB-1998‘,50 );INSERT INTO employees VALUES ( 182,‘Martha‘,‘Sullivan‘,‘MSULLIVA‘,‘650.507.9878‘,TO_DATE(‘21-JUN-1999‘,50 );INSERT INTO employees VALUES ( 183,‘Girard‘,‘Geoni‘,‘GGEONI‘,‘650.507.9879‘,TO_DATE(‘03-FEB-2000‘,50 );INSERT INTO employees VALUES ( 184,‘Nandita‘,‘Sarchand‘,‘NSARCHAN‘,‘650.509.1876‘,TO_DATE(‘27-JAN-1996‘,50 );INSERT INTO employees VALUES ( 185,‘Alexis‘,‘Bull‘,‘ABULL‘,‘650.509.2876‘,TO_DATE(‘20-FEB-1997‘,4100,50 );INSERT INTO employees VALUES ( 186,‘Dellinger‘,‘JDELLING‘,‘650.509.3876‘,TO_DATE(‘24-JUN-1998‘,3400,50 );INSERT INTO employees VALUES ( 187,‘Anthony‘,‘Cabrio‘,‘ACABRIO‘,‘650.509.4876‘,50 );INSERT INTO employees VALUES ( 188,‘Kelly‘,‘Chung‘,‘KCHUNG‘,‘650.505.1876‘,TO_DATE(‘14-JUN-1997‘,3800,50 );INSERT INTO employees VALUES ( 189,‘Jennifer‘,‘Dilly‘,‘JDILLY‘,‘650.505.2876‘,TO_DATE(‘13-AUG-1997‘,50 );INSERT INTO employees VALUES ( 190,‘Timothy‘,‘Gates‘,‘TGATES‘,‘650.505.3876‘,TO_DATE(‘11-JUL-1998‘,50 );INSERT INTO employees VALUES ( 191,‘Perkins‘,‘RPERKINS‘,‘650.505.4876‘,TO_DATE(‘19-DEC-1999‘,50 );INSERT INTO employees VALUES ( 192,‘Sarah‘,‘Bell‘,‘SBELL‘,‘650.501.1876‘,TO_DATE(‘04-FEB-1996‘,50 );INSERT INTO employees VALUES ( 193,‘Britney‘,‘Everett‘,‘BEVERETT‘,‘650.501.2876‘,TO_DATE(‘03-MAR-1997‘,3900,50 );INSERT INTO employees VALUES ( 194,‘Samuel‘,‘McCain‘,‘SMCCAIN‘,‘650.501.3876‘,TO_DATE(‘01-JUL-1998‘,50 );INSERT INTO employees VALUES ( 195,‘Vance‘,‘Jones‘,‘VJONES‘,‘650.501.4876‘,TO_DATE(‘17-MAR-1999‘,50 );INSERT INTO employees VALUES ( 196,‘Alana‘,‘Walsh‘,‘AWALSH‘,‘650.507.9811‘,TO_DATE(‘24-APR-1998‘,50 );INSERT INTO employees VALUES ( 197,‘Feeney‘,‘KFEENEY‘,‘650.507.9822‘,TO_DATE(‘23-MAY-1998‘,50 );INSERT INTO employees VALUES ( 198,‘Donald‘,‘OConnell‘,‘DOCONNEL‘,‘650.507.9833‘,50 );INSERT INTO employees VALUES ( 199,‘Douglas‘,‘DGRANT‘,‘650.507.9844‘,TO_DATE(‘13-JAN-2000‘,50 );INSERT INTO employees VALUES ( 200,‘Whalen‘,‘JWHALEN‘,‘515.123.4444‘,TO_DATE(‘17-SEP-1987‘,‘AD_ASST‘,4400,10 );INSERT INTO employees VALUES ( 201,‘Hartstein‘,‘MHARTSTE‘,‘515.123.5555‘,TO_DATE(‘17-FEB-1996‘,‘MK_MAN‘,13000,20 );INSERT INTO employees VALUES ( 202,‘Pat‘,‘Fay‘,‘PFAY‘,‘603.123.6666‘,TO_DATE(‘17-AUG-1997‘,‘MK_REP‘,20 );INSERT INTO employees VALUES ( 203,‘Susan‘,‘Mavris‘,‘SMAVRIS‘,‘515.123.7777‘,TO_DATE(‘07-JUN-1994‘,‘HR_REP‘,40 );INSERT INTO employees VALUES ( 204,‘Hermann‘,‘Baer‘,‘HBAER‘,‘515.123.8888‘,‘PR_REP‘,70 );INSERT INTO employees VALUES ( 205,‘Shelley‘,‘Higgins‘,‘SHIGGINS‘,‘515.123.8080‘,‘AC_MGR‘,110 );INSERT INTO employees VALUES ( 206,‘Gietz‘,‘WGIETZ‘,‘515.123.8181‘,‘AC_ACCOUNT‘,8300,110 );REM ********* insert data into the JOB_HISTORY tablePrompt ****** Populating JOB_HISTORY table ....INSERT INTO job_historyVALUES (102,TO_DATE(‘24-JUL-1998‘,60);INSERT INTO job_historyVALUES (101,TO_DATE(‘27-OCT-1993‘,110);INSERT INTO job_historyVALUES (101,TO_DATE(‘28-OCT-1993‘,TO_DATE(‘15-MAR-1997‘,110);INSERT INTO job_historyVALUES (201,20);INSERT INTO job_historyVALUES (114,TO_DATE(‘31-DEC-1999‘,50 );INSERT INTO job_historyVALUES (122,TO_DATE(‘01-JAN-1999‘,50 );INSERT INTO job_historyVALUES (200,TO_DATE(‘17-JUN-1993‘,90 );INSERT INTO job_historyVALUES (176,TO_DATE(‘31-DEC-1998‘,80 );INSERT INTO job_historyVALUES (176,80 );INSERT INTO job_historyVALUES (200,TO_DATE(‘01-JUL-1994‘,90 );REM enable integrity constraint to DEPARTMENTSALTER TABLE departments ENABLE CONSTRAINT dept_mgr_fk;COMMIT;

（编辑：温州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!