Tyler Muth’s Blog

Technology with a focus on Oracle, Application Express and Linux

Employees Sample Data Simplified

Posted by Tyler Muth on February 16, 2010

I use the HR schema sample data for a lot of examples or when I just need to work through a problem.  It’s great data, but many times I want to use the EMPLOYEES table without joining in DEPARTMENTS and JOBS as well as a self join of EMPLOYEES to get the manager name.  So, I used the following CTAS to create a simplified EMPLOYEES_ROLLUP table. I then exported the data as insert statements using SQL Developer (love that feature).

create table employees_rollup as
select e.employee_id,e.first_name, e.last_name, lower(e.email)||'@nowhere.com' email, e.phone_number, e.hire_date,e.salary,
       j.job_title,
       e2.first_name ||' '|| e2.last_name manager,e.manager_id,
       d.department_name
  from hr.employees e, hr.departments d, hr.employees e2, hr.jobs j
 where e.department_id = d.department_id
   and e.manager_id = e2.employee_id
   and e.job_id = j.job_id
/

The result is:

select * from employees_rollup;

EMPLOYEE_ID            FIRST_NAME           LAST_NAME                 EMAIL                                 PHONE_NUMBER         HIRE_DATE                 SALARY                 JOB_TITLE                           MANAGER                                        MANAGER_ID             DEPARTMENT_NAME
---------------------- -------------------- ------------------------- ------------------------------------- -------------------- ------------------------- ---------------------- ----------------------------------- ---------------------------------------------- ---------------------- ------------------------------
200                    Jennifer             Whalen                    jwhalen@nowhere.com                      515.123.4444                  17-SEP-87                 4400                   Administration Assistant            Neena Kochhar                                  101                    Administration
201                    Michael              Hartstein                 mhartste@nowhere.com                  515.123.5555         17-FEB-96                 13000                  Marketing Manager                   Steven King                                    100                    Marketing
202                    Pat                  Fay                       pfay@nowhere.com                      603.123.6666         17-AUG-97                 6000                   Marketing Representative            Michael Hartstein                              201                    Marketing

Unroll the following code block to the full DDL including insert statements (hint: you can use “View Source” or “Copy to Clipboard” on the overlay panel to save it locally):

create table employees_rollup (
	employee_id number(6,0), 
	first_name varchar2(35), 
	last_name varchar2(35), 
	email varchar2(100), 
	phone_number varchar2(20), 
	hire_date date, 
	salary number(8,2), 
	job_title varchar2(50), 
	manager varchar2(70), 
	manager_id number(6,0), 
	department_name varchar2(50) not null enable, 
	 constraint employees_rollup_pk primary key (employee_id) enable
)
/

create index employees_rollup_idx1 on employees_rollup(first_name,last_name)
/
create index employees_rollup_idx2 on employees_rollup(department_name)
/
create index employees_rollup_idx3 on employees_rollup(hire_date)
/
create index employees_rollup_idx4 on employees_rollup(employee_id,manager_id)
/
 

Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (200,'Jennifer','Whalen','jwhalen@nowhere.com','515.123.4444',to_timestamp('17-SEP-87 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),4400,'Administration Assistant','Neena Kochhar',101,'Administration')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (201,'Michael','Hartstein','mhartste@nowhere.com','515.123.5555',to_timestamp('17-FEB-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),13000,'Marketing Manager','Steven King',100,'Marketing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (202,'Pat','Fay','pfay@nowhere.com','603.123.6666',to_timestamp('17-AUG-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),6000,'Marketing Representative','Michael Hartstein',201,'Marketing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (115,'Alexander','Khoo','akhoo@nowhere.com','515.127.4562',to_timestamp('18-MAY-95 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3100,'Purchasing Clerk','Den Raphaely',114,'Purchasing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (116,'Shelli','Baida','sbaida@nowhere.com','515.127.4563',to_timestamp('24-DEC-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2900,'Purchasing Clerk','Den Raphaely',114,'Purchasing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (117,'Sigal','Tobias','stobias@nowhere.com','515.127.4564',to_timestamp('24-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2800,'Purchasing Clerk','Den Raphaely',114,'Purchasing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (118,'Guy','Himuro','ghimuro@nowhere.com','515.127.4565',to_timestamp('15-NOV-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2600,'Purchasing Clerk','Den Raphaely',114,'Purchasing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (119,'Karen','Colmenares','kcolmena@nowhere.com','515.127.4566',to_timestamp('10-AUG-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2500,'Purchasing Clerk','Den Raphaely',114,'Purchasing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (114,'Den','Raphaely','drapheal@nowhere.com','515.127.4561',to_timestamp('07-DEC-94 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),11000,'Purchasing Manager','Steven King',100,'Purchasing')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (203,'Susan','Mavris','smavris@nowhere.com','515.123.7777',to_timestamp('07-JUN-94 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),6500,'Human Resources Representative','Neena Kochhar',101,'Human Resources')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (198,'Donald','OConnell','doconnel@nowhere.com','650.507.9833',to_timestamp('21-JUN-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2600,'Shipping Clerk','Kevin Mourgos',124,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (199,'Douglas','Grant','dgrant@nowhere.com','650.507.9844',to_timestamp('13-JAN-00 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2600,'Shipping Clerk','Kevin Mourgos',124,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (141,'Trenna','Rajs','trajs@nowhere.com','650.121.8009',to_timestamp('17-OCT-95 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3500,'Stock Clerk','Kevin Mourgos',124,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (142,'Curtis','Davies','cdavies@nowhere.com','650.121.2994',to_timestamp('29-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3100,'Stock Clerk','Kevin Mourgos',124,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (143,'Randall','Matos','rmatos@nowhere.com','650.121.2874',to_timestamp('15-MAR-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2600,'Stock Clerk','Kevin Mourgos',124,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (144,'Peter','Vargas','pvargas@nowhere.com','650.121.2004',to_timestamp('09-JUL-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2500,'Stock Clerk','Kevin Mourgos',124,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (137,'Renske','Ladwig','rladwig@nowhere.com','650.121.1234',to_timestamp('14-JUL-95 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3600,'Stock Clerk','Shanta Vollman',123,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (138,'Stephen','Stiles','sstiles@nowhere.com','650.121.2034',to_timestamp('26-OCT-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3200,'Stock Clerk','Shanta Vollman',123,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (139,'John','Seo','jseo@nowhere.com','650.121.2019',to_timestamp('12-FEB-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2700,'Stock Clerk','Shanta Vollman',123,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (140,'Joshua','Patel','jpatel@nowhere.com','650.121.1834',to_timestamp('06-APR-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2500,'Stock Clerk','Shanta Vollman',123,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (133,'Jason','Mallin','jmallin@nowhere.com','650.127.1934',to_timestamp('14-JUN-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3300,'Stock Clerk','Payam Kaufling',122,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (134,'Michael','Rogers','mrogers@nowhere.com','650.127.1834',to_timestamp('26-AUG-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2900,'Stock Clerk','Payam Kaufling',122,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (135,'Ki','Gee','kgee@nowhere.com','650.127.1734',to_timestamp('12-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2400,'Stock Clerk','Payam Kaufling',122,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (136,'Hazel','Philtanker','hphiltan@nowhere.com','650.127.1634',to_timestamp('06-FEB-00 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2200,'Stock Clerk','Payam Kaufling',122,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (129,'Laura','Bissot','lbissot@nowhere.com','650.124.5234',to_timestamp('20-AUG-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3300,'Stock Clerk','Adam Fripp',121,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (130,'Mozhe','Atkinson','matkinso@nowhere.com','650.124.6234',to_timestamp('30-OCT-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2800,'Stock Clerk','Adam Fripp',121,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (131,'James','Marlow','jamrlow@nowhere.com','650.124.7234',to_timestamp('16-FEB-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2500,'Stock Clerk','Adam Fripp',121,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (132,'TJ','Olson','tjolson@nowhere.com','650.124.8234',to_timestamp('10-APR-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2100,'Stock Clerk','Adam Fripp',121,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (125,'Julia','Nayer','jnayer@nowhere.com','650.124.1214',to_timestamp('16-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3200,'Stock Clerk','Matthew Weiss',120,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (126,'Irene','Mikkilineni','imikkili@nowhere.com','650.124.1224',to_timestamp('28-SEP-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2700,'Stock Clerk','Matthew Weiss',120,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (127,'James','Landry','jlandry@nowhere.com','650.124.1334',to_timestamp('14-JAN-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2400,'Stock Clerk','Matthew Weiss',120,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (128,'Steven','Markle','smarkle@nowhere.com','650.124.1434',to_timestamp('08-MAR-00 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2200,'Stock Clerk','Matthew Weiss',120,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (120,'Matthew','Weiss','mweiss@nowhere.com','650.123.1234',to_timestamp('18-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),8000,'Stock Manager','Steven King',100,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (121,'Adam','Fripp','afripp@nowhere.com','650.123.2234',to_timestamp('10-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),8200,'Stock Manager','Steven King',100,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (122,'Payam','Kaufling','pkauflin@nowhere.com','650.123.3234',to_timestamp('01-MAY-95 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),7900,'Stock Manager','Steven King',100,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (123,'Shanta','Vollman','svollman@nowhere.com','650.123.4234',to_timestamp('10-OCT-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),6500,'Stock Manager','Steven King',100,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (124,'Kevin','Mourgos','kmourgos@nowhere.com','650.123.5234',to_timestamp('16-NOV-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),5800,'Stock Manager','Steven King',100,'Shipping')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (104,'Bruce','Ernst','bernst@nowhere.com','590.423.4568',to_timestamp('21-MAY-91 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),6000,'Programmer','Alexander Hunold',103,'IT')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (105,'David','Austin','daustin@nowhere.com','590.423.4569',to_timestamp('25-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),4800,'Programmer','Alexander Hunold',103,'IT')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (106,'Valli','Pataballa','vpatabal@nowhere.com','590.423.4560',to_timestamp('05-FEB-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),4800,'Programmer','Alexander Hunold',103,'IT')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (107,'Diana','Lorentz','dlorentz@nowhere.com','590.423.5567',to_timestamp('07-FEB-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),4200,'Programmer','Alexander Hunold',103,'IT')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (103,'Alexander','Hunold','ahunold@nowhere.com','590.423.4567',to_timestamp('03-JAN-90 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),9000,'Programmer','Lex De Haan',102,'IT')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (204,'Hermann','Baer','hbaer@nowhere.com','515.123.8888',to_timestamp('07-JUN-94 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),10000,'Public Relations Representative','Neena Kochhar',101,'Public Relations')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (145,'John','Russell','jrussel@nowhere.com','011.44.1344.429268',to_timestamp('01-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),14000,'Sales Manager','Steven King',100,'Sales')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (101,'Neena','Kochhar','nkochhar@nowhere.com','515.123.4568',to_timestamp('21-SEP-89 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),17000,'Administration Vice President','Steven King',100,'Executive')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (102,'Lex','De Haan','ldehaan@nowhere.com','515.123.4569',to_timestamp('13-JAN-93 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),17000,'Administration Vice President','Steven King',100,'Executive')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (109,'Daniel','Faviet','dfaviet@nowhere.com','515.124.4169',to_timestamp('16-AUG-94 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),9000,'Accountant','Nancy Greenberg',108,'Finance')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (110,'John','Chen','jchen@nowhere.com','515.124.4269',to_timestamp('28-SEP-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),8200,'Accountant','Nancy Greenberg',108,'Finance')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (111,'Ismael','Sciarra','isciarra@nowhere.com','515.124.4369',to_timestamp('30-SEP-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),7700,'Accountant','Nancy Greenberg',108,'Finance')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (112,'Jose Manuel','Urman','jmurman@nowhere.com','515.124.4469',to_timestamp('07-MAR-98 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),7800,'Accountant','Nancy Greenberg',108,'Finance')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (113,'Luis','Popp','lpopp@nowhere.com','515.124.4567',to_timestamp('07-DEC-99 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),6900,'Accountant','Nancy Greenberg',108,'Finance')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (108,'Nancy','Greenberg','ngreenbe@nowhere.com','515.124.4569',to_timestamp('17-AUG-94 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),12000,'Finance Manager','Neena Kochhar',101,'Finance')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (205,'Shelley','Higgins','shiggins@nowhere.com','515.123.8080',to_timestamp('07-JUN-94 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),12000,'Accounting Manager','Neena Kochhar',101,'Accounting')
/
Insert into EMPLOYEES_ROLLUP (EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,SALARY,JOB_TITLE,MANAGER,MANAGER_ID,DEPARTMENT_NAME) values (206,'William','Gietz','wgietz@nowhere.com','515.123.8181',to_timestamp('07-JUN-94 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),8300,'Public Accountant','Shelley Higgins',205,'Accounting')
/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: