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')
/
Tyler Muth's Blog 
Leave a comment