0% found this document useful (0 votes)
14 views14 pages

SQL Employee Table Creation and Data

The document defines a SQL table named EMPLOYEES with various fields including EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, and others. It also includes multiple insert statements to populate the EMPLOYEES table with employee data, detailing their personal and job-related information. The data includes employee IDs, names, contact details, hire dates, job roles, salaries, and manager and department associations.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
14 views14 pages

SQL Employee Table Creation and Data

The document defines a SQL table named EMPLOYEES with various fields including EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, and others. It also includes multiple insert statements to populate the EMPLOYEES table with employee data, detailing their personal and job-related information. The data includes employee IDs, names, contact details, hire dates, job roles, salaries, and manager and department associations.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

CREATE TABLE EMPLOYEES

(
EMPLOYEES_ID NUMBER (6) NOT NULL ,
FIRST_NAME VARCHAR2 (20 BYTE) ,
LAST_NAME VARCHAR2 (25 BYTE) NOT NULL ,
EMAIL VARCHAR2 (25 BYTE) NOT NULL ,
PHONE_NUMBER VARCHAR2 (20 BYTE) ,
HIRE_DATE DATE NOT NULL ,
JOB_ID VARCHAR2 (10 BYTE) NOT NULL ,
SALARY NUMBER (8,2) ,
COMMISSION_PCT NUMBER (2,2) ,
MANAGER_ID NUMBER (6) ,
DEPARTMENT_ID NUMBER (4)
);

Insert into EMPLOYEES


(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(198, 'Donald', 'OConnell', 'DOCONNEL', '650.507.9833',
TO_DATE('06/21/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2600, 124,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(199, 'Douglas', 'Grant', 'DGRANT', '650.507.9844',
TO_DATE('01/13/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2600, 124,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(200, 'Jennifer', 'Whalen', 'JWHALEN', '515.123.4444',
TO_DATE('09/17/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_ASST', 4400, 101,
10);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(201, 'Michael', 'Hartstein', 'MHARTSTE', '515.123.5555',
TO_DATE('02/17/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MK_MAN', 13000, 100,
20);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(202, 'Pat', 'Fay', 'PFAY', '603.123.6666',
TO_DATE('08/17/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MK_REP', 6000, 201,
20);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(203, 'Susan', 'Mavris', 'SMAVRIS', '515.123.7777',
TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'HR_REP', 6500, 101,
40);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(204, 'Hermann', 'Baer', 'HBAER', '515.123.8888',
TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PR_REP', 10000, 101,
70);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(205, 'Shelley', 'Higgins', 'SHIGGINS', '515.123.8080',
TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC_MGR', 12000, 101,
110);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(206, 'William', 'Gietz', 'WGIETZ', '515.123.8181',
TO_DATE('06/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC_ACCOUNT', 8300,
205, 110);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, DEPARTMENT_ID)
Values
(100, 'Steven', 'King', 'SKING', '515.123.4567',
TO_DATE('06/17/1987 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_PRES', 24000, 90);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(101, 'Neena', 'Kochhar', 'NKOCHHAR', '515.123.4568',
TO_DATE('09/21/1989 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_VP', 17000, 100,
90);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(102, 'Lex', 'De Haan', 'LDEHAAN', '515.123.4569',
TO_DATE('01/13/1993 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AD_VP', 17000, 100,
90);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(103, 'Alexander', 'Hunold', 'AHUNOLD', '590.423.4567',
TO_DATE('01/03/1990 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 9000, 102,
60);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(104, 'Bruce', 'Ernst', 'BERNST', '590.423.4568',
TO_DATE('05/21/1991 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 6000, 103,
60);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(105, 'David', 'Austin', 'DAUSTIN', '590.423.4569',
TO_DATE('06/25/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 4800, 103,
60);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(106, 'Valli', 'Pataballa', 'VPATABAL', '590.423.4560',
TO_DATE('02/05/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 4800, 103,
60);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(107, 'Diana', 'Lorentz', 'DLORENTZ', '590.423.5567',
TO_DATE('02/07/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'IT_PROG', 4200, 103,
60);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(108, 'Nancy', 'Greenberg', 'NGREENBE', '515.124.4569',
TO_DATE('08/17/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_MGR', 12000, 101,
100);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(109, 'Daniel', 'Faviet', 'DFAVIET', '515.124.4169',
TO_DATE('08/16/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 9000,
108, 100);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(110, 'John', 'Chen', 'JCHEN', '515.124.4269',
TO_DATE('09/28/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 8200,
108, 100);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(111, 'Ismael', 'Sciarra', 'ISCIARRA', '515.124.4369',
TO_DATE('09/30/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 7700,
108, 100);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(112, 'Jose Manuel', 'Urman', 'JMURMAN', '515.124.4469',
TO_DATE('03/07/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 7800,
108, 100);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(113, 'Luis', 'Popp', 'LPOPP', '515.124.4567',
TO_DATE('12/07/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'FI_ACCOUNT', 6900,
108, 100);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(114, 'Den', 'Raphaely', 'DRAPHEAL', '515.127.4561',
TO_DATE('12/07/1994 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_MAN', 11000, 100,
30);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(115, 'Alexander', 'Khoo', 'AKHOO', '515.127.4562',
TO_DATE('05/18/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 3100, 114,
30);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(116, 'Shelli', 'Baida', 'SBAIDA', '515.127.4563',
TO_DATE('12/24/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2900, 114,
30);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(117, 'Sigal', 'Tobias', 'STOBIAS', '515.127.4564',
TO_DATE('07/24/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2800, 114,
30);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(118, 'Guy', 'Himuro', 'GHIMURO', '515.127.4565',
TO_DATE('11/15/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2600, 114,
30);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(119, 'Karen', 'Colmenares', 'KCOLMENA', '515.127.4566',
TO_DATE('08/10/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'PU_CLERK', 2500, 114,
30);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(120, 'Matthew', 'Weiss', 'MWEISS', '650.123.1234',
TO_DATE('07/18/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 8000, 100,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(121, 'Adam', 'Fripp', 'AFRIPP', '650.123.2234',
TO_DATE('04/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 8200, 100,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(122, 'Payam', 'Kaufling', 'PKAUFLIN', '650.123.3234',
TO_DATE('05/01/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 7900, 100,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(123, 'Shanta', 'Vollman', 'SVOLLMAN', '650.123.4234',
TO_DATE('10/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 6500, 100,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(124, 'Kevin', 'Mourgos', 'KMOURGOS', '650.123.5234',
TO_DATE('11/16/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_MAN', 5800, 100,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(125, 'Julia', 'Nayer', 'JNAYER', '650.124.1214',
TO_DATE('07/16/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3200, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(126, 'Irene', 'Mikkilineni', 'IMIKKILI', '650.124.1224',
TO_DATE('09/28/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2700, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(127, 'James', 'Landry', 'JLANDRY', '650.124.1334',
TO_DATE('01/14/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2400, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(128, 'Steven', 'Markle', 'SMARKLE', '650.124.1434',
TO_DATE('03/08/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2200, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(129, 'Laura', 'Bissot', 'LBISSOT', '650.124.5234',
TO_DATE('08/20/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3300, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(130, 'Mozhe', 'Atkinson', 'MATKINSO', '650.124.6234',
TO_DATE('10/30/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2800, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(131, 'James', 'Marlow', 'JAMRLOW', '650.124.7234',
TO_DATE('02/16/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2500, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(132, 'TJ', 'Olson', 'TJOLSON', '650.124.8234',
TO_DATE('04/10/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2100, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(133, 'Jason', 'Mallin', 'JMALLIN', '650.127.1934',
TO_DATE('06/14/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3300, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(134, 'Michael', 'Rogers', 'MROGERS', '650.127.1834',
TO_DATE('08/26/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2900, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(135, 'Ki', 'Gee', 'KGEE', '650.127.1734',
TO_DATE('12/12/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2400, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(136, 'Hazel', 'Philtanker', 'HPHILTAN', '650.127.1634',
TO_DATE('02/06/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2200, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(137, 'Renske', 'Ladwig', 'RLADWIG', '650.121.1234',
TO_DATE('07/14/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3600, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(138, 'Stephen', 'Stiles', 'SSTILES', '650.121.2034',
TO_DATE('10/26/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3200, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(139, 'John', 'Seo', 'JSEO', '650.121.2019',
TO_DATE('02/12/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2700, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(140, 'Joshua', 'Patel', 'JPATEL', '650.121.1834',
TO_DATE('04/06/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2500, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(141, 'Trenna', 'Rajs', 'TRAJS', '650.121.8009',
TO_DATE('10/17/1995 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3500, 124,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(142, 'Curtis', 'Davies', 'CDAVIES', '650.121.2994',
TO_DATE('01/29/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 3100, 124,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(143, 'Randall', 'Matos', 'RMATOS', '650.121.2874',
TO_DATE('03/15/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2600, 124,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(144, 'Peter', 'Vargas', 'PVARGAS', '650.121.2004',
TO_DATE('07/09/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'ST_CLERK', 2500, 124,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(145, 'John', 'Russell', 'JRUSSEL', '011.44.1344.429268',
TO_DATE('10/01/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 14000, 0.4,
100,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(146, 'Karen', 'Partners', 'KPARTNER', '011.44.1344.467268',
TO_DATE('01/05/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 13500, 0.3,
100,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(147, 'Alberto', 'Errazuriz', 'AERRAZUR', '011.44.1344.429278',
TO_DATE('03/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 12000, 0.3,
100,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(148, 'Gerald', 'Cambrault', 'GCAMBRAU', '011.44.1344.619268',
TO_DATE('10/15/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 11000, 0.3,
100,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(149, 'Eleni', 'Zlotkey', 'EZLOTKEY', '011.44.1344.429018',
TO_DATE('01/29/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_MAN', 10500, 0.2,
100,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(150, 'Peter', 'Tucker', 'PTUCKER', '011.44.1344.129268',
TO_DATE('01/30/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10000, 0.3,
145,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(151, 'David', 'Bernstein', 'DBERNSTE', '011.44.1344.345268',
TO_DATE('03/24/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9500, 0.25,
145,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(152, 'Peter', 'Hall', 'PHALL', '011.44.1344.478968',
TO_DATE('08/20/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9000, 0.25,
145,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(153, 'Christopher', 'Olsen', 'COLSEN', '011.44.1344.498718',
TO_DATE('03/30/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8000, 0.2,
145,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(154, 'Nanette', 'Cambrault', 'NCAMBRAU', '011.44.1344.987668',
TO_DATE('12/09/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7500, 0.2,
145,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(155, 'Oliver', 'Tuvault', 'OTUVAULT', '011.44.1344.486508',
TO_DATE('11/23/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7000, 0.15,
145,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(156, 'Janette', 'King', 'JKING', '011.44.1345.429268',
TO_DATE('01/30/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10000, 0.35,
146,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(157, 'Patrick', 'Sully', 'PSULLY', '011.44.1345.929268',
TO_DATE('03/04/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9500, 0.35,
146,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(158, 'Allan', 'McEwen', 'AMCEWEN', '011.44.1345.829268',
TO_DATE('08/01/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9000, 0.35,
146,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(159, 'Lindsey', 'Smith', 'LSMITH', '011.44.1345.729268',
TO_DATE('03/10/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8000, 0.3,
146,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(160, 'Louise', 'Doran', 'LDORAN', '011.44.1345.629268',
TO_DATE('12/15/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7500, 0.3,
146,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(161, 'Sarath', 'Sewall', 'SSEWALL', '011.44.1345.529268',
TO_DATE('11/03/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7000, 0.25,
146,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(162, 'Clara', 'Vishney', 'CVISHNEY', '011.44.1346.129268',
TO_DATE('11/11/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10500, 0.25,
147,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(163, 'Danielle', 'Greene', 'DGREENE', '011.44.1346.229268',
TO_DATE('03/19/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9500, 0.15,
147,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(164, 'Mattea', 'Marvins', 'MMARVINS', '011.44.1346.329268',
TO_DATE('01/24/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7200, 0.1,
147,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(165, 'David', 'Lee', 'DLEE', '011.44.1346.529268',
TO_DATE('02/23/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6800, 0.1,
147,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(166, 'Sundar', 'Ande', 'SANDE', '011.44.1346.629268',
TO_DATE('03/24/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6400, 0.1,
147,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(167, 'Amit', 'Banda', 'ABANDA', '011.44.1346.729268',
TO_DATE('04/21/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6200, 0.1,
147,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(168, 'Lisa', 'Ozer', 'LOZER', '011.44.1343.929268',
TO_DATE('03/11/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 11500, 0.25,
148,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(169, 'Harrison', 'Bloom', 'HBLOOM', '011.44.1343.829268',
TO_DATE('03/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 10000, 0.2,
148,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(170, 'Tayler', 'Fox', 'TFOX', '011.44.1343.729268',
TO_DATE('01/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 9600, 0.2,
148,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(171, 'William', 'Smith', 'WSMITH', '011.44.1343.629268',
TO_DATE('02/23/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7400, 0.15,
148,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(172, 'Elizabeth', 'Bates', 'EBATES', '011.44.1343.529268',
TO_DATE('03/24/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7300, 0.15,
148,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(173, 'Sundita', 'Kumar', 'SKUMAR', '011.44.1343.329268',
TO_DATE('04/21/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6100, 0.1,
148,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(174, 'Ellen', 'Abel', 'EABEL', '011.44.1644.429267',
TO_DATE('05/11/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 11000, 0.3,
149,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(175, 'Alyssa', 'Hutton', 'AHUTTON', '011.44.1644.429266',
TO_DATE('03/19/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8800, 0.25,
149,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(176, 'Jonathon', 'Taylor', 'JTAYLOR', '011.44.1644.429265',
TO_DATE('03/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8600, 0.2,
149,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(177, 'Jack', 'Livingston', 'JLIVINGS', '011.44.1644.429264',
TO_DATE('04/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 8400, 0.2,
149,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID)
Values
(178, 'Kimberely', 'Grant', 'KGRANT', '011.44.1644.429263',
TO_DATE('05/24/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 7000, 0.15,
149);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(179, 'Charles', 'Johnson', 'CJOHNSON', '011.44.1644.429262',
TO_DATE('01/04/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SA_REP', 6200, 0.1,
149,
80);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(180, 'Winston', 'Taylor', 'WTAYLOR', '650.507.9876',
TO_DATE('01/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3200, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(181, 'Jean', 'Fleaur', 'JFLEAUR', '650.507.9877',
TO_DATE('02/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3100, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(182, 'Martha', 'Sullivan', 'MSULLIVA', '650.507.9878',
TO_DATE('06/21/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2500, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(183, 'Girard', 'Geoni', 'GGEONI', '650.507.9879',
TO_DATE('02/03/2000 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2800, 120,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(184, 'Nandita', 'Sarchand', 'NSARCHAN', '650.509.1876',
TO_DATE('01/27/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 4200, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(185, 'Alexis', 'Bull', 'ABULL', '650.509.2876',
TO_DATE('02/20/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 4100, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(186, 'Julia', 'Dellinger', 'JDELLING', '650.509.3876',
TO_DATE('06/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3400, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(187, 'Anthony', 'Cabrio', 'ACABRIO', '650.509.4876',
TO_DATE('02/07/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3000, 121,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(188, 'Kelly', 'Chung', 'KCHUNG', '650.505.1876',
TO_DATE('06/14/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3800, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(189, 'Jennifer', 'Dilly', 'JDILLY', '650.505.2876',
TO_DATE('08/13/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3600, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(190, 'Timothy', 'Gates', 'TGATES', '650.505.3876',
TO_DATE('07/11/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2900, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(191, 'Randall', 'Perkins', 'RPERKINS', '650.505.4876',
TO_DATE('12/19/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2500, 122,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(192, 'Sarah', 'Bell', 'SBELL', '650.501.1876',
TO_DATE('02/04/1996 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 4000, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(193, 'Britney', 'Everett', 'BEVERETT', '650.501.2876',
TO_DATE('03/03/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3900, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(194, 'Samuel', 'McCain', 'SMCCAIN', '650.501.3876',
TO_DATE('07/01/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3200, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(195, 'Vance', 'Jones', 'VJONES', '650.501.4876',
TO_DATE('03/17/1999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 2800, 123,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(196, 'Alana', 'Walsh', 'AWALSH', '650.507.9811',
TO_DATE('04/24/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3100, 124,
50);
Insert into EMPLOYEES
(EMPLOYEES_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID,
SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(197, 'Kevin', 'Feeney', 'KFEENEY', '650.507.9822',
TO_DATE('05/23/1998 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'SH_CLERK', 3000, 124,
50);
COMMIT;

You might also like