Vadivelan's Tech Blog

SQL Queries Asked in Interviews

Queries:

1) There is a table which contains two columns Student and Marks, you need to find all the students, whose marks are greater than average marks i.e. list of above-average students Click Here

SELECT Student
FROM <tablename>
WHERE Marks > (SELECT AVG(Marks) FROM <tablename>);

(or)

SELECT Student, Marks
FROM ( SELECT Student,
                             Marks,
                             AVG(Marks) over () AS AvgMark
             FROM <tablename>) S

WHERE Marks > AvgMark;

2) What is High Water Mark in Oracle? Click Here

The high water mark (HWM) for an Oracle table is a construct that shows the table at its greatest size.
The issue with the high water mark is that full-table scans will always read up to the high water mark.
The remedy for a too-high high water mark (e.g. a fragmented table will lots of empty blocks) is to reorganize the table with
Data Pump (expdp and impdp),
the dbms_redefinition utility, or

with the table shrink or coalesce.

3) PLSQL Interview Questions. Click Here

Query to find 2nd top salary in each department

Conventional Query:

select

department_id,

last_name,

salary

from employees e

where 1 = (select count(distinct salary)

from employees e2

where e2.salary > e.salary and e2.department_id = e.department_id)

order by department_id;

Analytical Query:

Select department_id, last_name, salary

from (select e.department_id, last_name, salary,

dense_rank() over (partition by department_id order by salary desc) rank

from employees e)

where rank = 2

order by department_id;

Returning comma separated list

To return a comma separated list of employees in each department we use the LISTAGG Analytical Function as below.

SELECT department_id, LISTAGG(First_Name,',') WITHIN GROUP (ORDER BY First_Name)
FROM employees
GROUP BY department_id
ORDER BY department_id;

Department Id	Employees
10	Jennifer
20	Michael,Pat
30	Alexander,Den,Guy,Karen,Shelli,Sigal
40	Susan
50	Adam,Alana,Alexis,Anthony,Britney,Curtis,Donald,Douglas, Girard,Hazel,Irene,James,James,Jason,Jean,Jennifer,John, Joshua,Julia,Julia,Kelly,Kevin,Kevin,Ki,Laura,Martha, Matthew,Michael,Mozhe,Nandita,Payam,Peter,Randall,Randall, Renske,Samuel,Sarah,Shanta,Stephen,Steven,TJ, Timothy,Trenna,Vance,Winston
60	Alexander,Bruce,David,Diana,Valli
70	Hermann
80	Alberto,Allan,Alyssa,Amit,Charles,Christopher,Clara, Danielle,David,David,Eleni,Elizabeth,Ellen,Gerald,Harrison, Jack,Janette,John,Jonathon,Karen,Lindsey,Lisa,Louise,Mattea, Nanette,Oliver,Patrick,Peter,Peter,Sarath,Sundar,Sundita,Tayler, William
90	Lex,Neena,Steven
100	Daniel,Ismael,John,Jose Manuel,Luis,Nancy
110	Shelley,William
	Kimberely

In the results we see some duplicates, if we want to remove the duplicates then we use the distinct keyword as below.

SELECT department_id

, LISTAGG( DISTINCT First_Name,',') WITHIN GROUP (ORDER BY First_Name)
FROM employees
GROUP BY department_id
ORDER BY department_id;

Department Id	Employees
10	Jennifer
20	Michael,Pat
30	Alexander,Den,Guy,Karen,Shelli,Sigal
40	Susan
50	Adam,Alana,Alexis,Anthony,Britney,Curtis,Donald, Douglas,Girard,Hazel,Irene,James,Jason,Jean,Jennifer, John,Joshua,Julia,Kelly,Kevin,Ki,Laura, Martha,Matthew,Michael,Mozhe,Nandita, Payam,Peter,Randall,Renske, Samuel,Sarah,Shanta,Stephen,Steven,TJ,Timothy, Trenna,Vance,Winston
60	Alexander,Bruce,David,Diana,Valli
70	Hermann
80	Alberto,Allan,Alyssa,Amit,Charles,Christopher, Clara,Danielle,David,Eleni, Elizabeth,Ellen,Gerald,Harrison,Jack,Janette, John,Jonathon,Karen,Lindsey, Lisa,Louise,Mattea,Nanette,Oliver,Patrick,Peter, Sarath,Sundar,Sundita,Tayler, William
90	Lex,Neena,Steven
100	Daniel,Ismael,John,Jose Manuel,Luis,Nancy
110	Shelley,William
	Kimberely

There is another way to do this in Oracle 21c

SELECT department_name,

CURSOR(SELECT salary, commission_pct

FROM employees e

WHERE e.department_id = d.department_id)

FROM departments d

ORDER BY department_name

How to find the 2nd lowest salary in each department

SELECT

department_id, first_name, salary,

NTH_VALUE(salary, 2) OVER (PARTITION BY department_id

ORDER BY salary

RANGE BETWEEN UNBOUNDED PRECEDING

AND UNBOUNDED FOLLOWING) "2nd_lowest_sal"

FROM employees

ORDER BY department_id, salary;

Cut Command in Shell Programming

The cut command in UNIX is a command for cutting out the sections from each line of files and writing the result to standard output. It can be used to cut parts of a line by byte position, character and field. Basically the cut command slices a line and extracts the text. It is necessary to specify option with command otherwise it gives error. If more than one file name is provided then data from each file is not precedes by its file name.

$cut -d "delimiter" -f (field number) file.txt

[opc@instance-2 ~]$ cat myFirstScript.txt
pwd
This is my FirstScript
Once upon a time there lived a great king.
He was very kind and have never let any one down.

[opc@instance-2 ~]$ cut -d " " -f 1,5 myFirstScript.txt
pwd
This
Once there
He and

[opc@instance-2 ~]$ cut -d " " -f 1-5 myFirstScript.txt
pwd
This is my FirstScript
Once upon a time there
He was very kind and

https://www.geeksforgeeks.org/cut-command-linux-examples/

How to view a SQL query execution Plan in Oracle SQL*Plus

CLICK HERE

SQL> explain plan for
select d.department_name, e.first_name, e.salary,

sum(e.salary) over (partition by e.department_id order by e.first_name) running_total

from employees e
left join departments d on e.department_id = d.department_id
order by d.department_name, e.first_name;

SQL> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());

Write a Query to return Running Total of employees Salary within each department.

select d.department_name, e.first_name, e.salary, sum(e.salary) over (partition by e.department_id order by e.first_name) running_total

from employees e

left join departments d on e.department_id = d.department_id

order by d.department_name, e.first_name

Fetch managers who has both genders reporting to them in every department

In this post I wan't to prepare a query to fetch all the managers who has a male and a female employee reporting to them in every department.

Schema Setup:

create table dept
(dept_id number(3),
dept_name varchar2(100));

insert into dept (dept_id, dept_name) values (1, 'Dept A');
insert into dept (dept_id, dept_name) values (2, 'Dept B');
insert into dept (dept_id, dept_name) values (3, 'Dept C');

create table emp

(number (3),

emp_name varchar2 (100),

mgr_id number (3),

dept_id number (3),

gender varchar2 (1));

Note: In the below data set only Manager 3 has both male and females reporting to him in all the departments.

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (1, 'Vadi', 1, 1, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (2, 'Deepak', 1, 1, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (3, 'Praveen', 1, 2, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (4, 'Sharan', 1, 2, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (5, 'Ananya', 1, 2, 'F');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (6, 'Suresh', 2, 1, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (7, 'Rithu', 2, 1, 'F');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (8, 'Ravi', 2, 2, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (9, 'Arpitha', 2, 2, 'F');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (16, 'Anand', 2, 3, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (10, 'Supra', 3, 1, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (11, 'Shalini', 3, 1, 'F');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (12, 'Murugan', 3, 2, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (13, 'Kavitha', 3, 2, 'F');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (14, 'Patric', 3, 3, 'M');

insert into emp (emp_id, emp_name, mgr_id, dept_id, gender) values (15, 'Lisa', 3, 3, 'F');

Solution:

Write a query on EMP.

Group employees by Manager, department and find number of genders reporting to managers.

Apply a filter to get only the group in which managers have 2 genders

Now, apply a rank function within each managers window by dept.

Finally, fetch only the managers who have the record with highest rank that is equal to the total number of departments.

Use a CTE to arrive at total number of departments.

WITH no_of_depts AS (select count (dept_id) total_no_of_dept from dept)

select mgr_id

from ( select m.mgr_id, dept_id, count (distinct m.gender) no_of_genders,

rank () over (partition by mgr_id order by dept_id) rank

from emp m

group by m.mgr_id, m.dept_id

having count (distinct m.gender) = 2

order by m.mgr_id, m.dept_id

)

where rank = (select total_no_of_dept from no_of_depts);

MGR_ID

----------

1 row selected.

Now, if I need to print the number of genders reporting to each manager across every department in the org, then I will need a rowset matrix to be used in my CTE for reference against the managers across every department.

select distinct mgr_id, d.dept_id

from emp m cross join dept d

group by mgr_id, d.dept_id

order by mgr_id, d.dept_id;

MGR_ID | DEPT_ID

---------- | ----------

1 1

1 2

1 3

2 1

2 2

2 3

3 1

3 2

3 3

9 rows selected.

I need to join this CTE with the EMP table to get the number of genders reporting to them in each department. It will be 0,1 or 2.

0-- No employees reporting to them

1-- Either Male or Female reporting to them in the department

2-- Both Male and Female reporting to them in the department

WITH mgr_4_all_depts AS

(

select distinct mgr_id, d.dept_id

from emp m cross join dept d

group by mgr_id, d.dept_id

)

SELECT d.mgr_id, d.dept_id, COUNT (DISTINCT m.gender) no_of_genders

FROM mgr_4_all_depts d

LEFT JOIN emp m ON m.dept_id = d.dept_id AND m.mgr_id = d.mgr_id

GROUP BY d.mgr_id, d.dept_id

ORDER BY d.mgr_id, d.dept_id;

MGR_ID | DEPT_ID | NO_OF_GENDERS

---------- | ---------- | -------------

1 1 1

1 2 2

1 3 0

2 1 2

2 2 2

2 3 1

3 1 2

3 2 2

3 3 2

9 rows selected.

The above query only tells me that if there are 1 gender OR 2 genders OR no employees reporting to the managers in each department.

If I need to know the details of the gender as well, then I should be taking this CTE table and join it with employees.

Group them by manager, dept and gender.

Apply the LISTAGG analytical function to get comma separated list of genders within each group.

Apply a distinct function to eliminate the repeating groups.

WITH mgr_4_all_depts AS

(

select distinct mgr_id, d.dept_id

from emp m cross join dept d

group by mgr_id, d.dept_id

)

SELECT DISTINCT d.mgr_id, d.dept_id,

NVL(LISTAGG (m.gender, ',')

WITHIN GROUP (ORDER BY m.gender)

OVER (PARTITION BY d.mgr_id, d.dept_id),'--') genders_reporting

FROM mgr_4_all_depts d

LEFT JOIN

emp m ON m.dept_id = d.dept_id AND m.mgr_id = d.mgr_id

GROUP BY d.mgr_id, d.dept_id, m.gender

ORDER BY d.mgr_id, d.dept_id;

MGR_ID | DEPT_ID | GENDERS_REPORTING

------ | ------ | ------------------

1 1 M

1 2 F,M

1 3 --

2 1 F,M

2 2 F,M

2 3 M

3 1 F,M

3 2 F,M

3 3 F,M

Analytic FIFO picking

I'm putting a link to this blog of Kim Berg Hansen to have it for my personal reference.

http://www.kibeha.dk/2011/07/analytic-fifo-picking.html

SELECT ordno,
item,
ord_qty,
loc,
loc_qty,
purch,
LEAST (loc_qty, ord_qty - NVL (picked_qty, 0)) pick_qty
FROM (SELECT ol.ordno,
ol.item,
ol.qty ord_qty,
i.loc,
i.qty loc_qty,
i.purch,
SUM (
i.qty)
OVER (PARTITION BY i.item
ORDER BY purch, loc
ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING)
picked_qty
FROM inventory i, orderline ol
WHERE i.item = ol.item)
WHERE NVL (picked_qty, 0) < ord_qty;

ORDNO ITEM ORD_QTY LOC LOC_QTY PURCH PICK_QTY
---------- ---------- ---------- ---------- ---------- --------- ----------
1 A1 24 1-A-20 18 01-NOV-04 18
1 A1 24 2-A-02 24 02-NOV-04 6
1 B1 18 1-B-15 2 02-NOV-04 2
1 B1 18 1-C-04 12 03-NOV-04 12
1 B1 18 2-D-23 1 04-NOV-04 1
1 B1 18 1-B-11 4 05-NOV-04 3

6 rows selected.

How to generate sample test data

Step 1:
Let us just say if where have a table with the below structure
SQL> desc address
Name Null? Type
----------------------------------------- -------- ------------
STREET VARCHAR2(32)
CITY VARCHAR2(20)
STATE CHAR(2)
POSTAL_CODE VARCHAR2(6)

Step2:
Use the dbms_random package to generate sample data to populate this table.
I agree this is not generating any meaningful data, but it just can be used to populate data for testing purpose.
SQL> INSERT INTO address
2 SELECT DBMS_RANDOM.STRING ('a', 32) street,
3 DBMS_RANDOM.STRING ('a', 20) city,
4 DBMS_RANDOM.STRING ('u', 2) state,
5 ROUND (DBMS_RANDOM.VALUE (90000, 99999)) zip
6 FROM DUAL
7 CONNECT BY LEVEL <= 1000;

1000 rows created.

Step3:
Below is a sample data

In this post I'm going to share some examples of passing collections as an out variable from Oracle PLSQL Stored Procedures and also Returning a collection object from a function and using it in a query to directly populate a Oracle Table.

Generating a simple Style Sheet for Displaying Departments and Employees Data in the Web

In my previous post I detailed steps about generating a xml document for records in Departments and Employees table in HR Schema.

In this post I'm detailing the steps to create a StyleSheet (XSL) document and displaying the XML content in a readable format by referring the style sheet in the xml document.

--------------------------------------------------------------------------------------
I created this Style Sheet by editing an existing style sheet obtained from the web and saved it as deptStyleSheet.xsl

---------------------------------------------
<?xml version="1.0"?>

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<html>
<body bgcolor="#FFFFDB"><center>
<h2><font color="#0000FF">Departments and Employees</font></h2>
<table border="1" bgcolor="#85C2FF">
<tr>
<th>DEPARTMENT_ID</th>
<th>DEPARTMENT_NAME</th>
<th>MANAGER_ID</th>
<th>LOCATION_ID</th>
<th>
<table border="1" bgcolor="#85C2FE">
<tr>
<th colspan="9">EMP_DETAILS</th>
</tr>
<tr>
<th>EMPLOYEE_ID</th>
<th>FIRST_NAME</th>
<th>LAST_NAME</th>
<th>EMAIL</th>
<th>PHONE_NUMBER</th>
<th>HIRE_DATE</th>
<th>JOB_ID</th>
<th>SALARY</th>
<th>MANAGER_ID</th>
</tr>
</table>
</th>
</tr>
<xsl:for-each select="ROW/DEPT">
<tr bgcolor="#CEE7FF">
<td><xsl:value-of select="DEPARTMENT_ID"/></td>
<td><xsl:value-of select="DEPARTMENT_NAME"/></td>
<td><xsl:value-of select="MANAGER_ID"/></td>
<td><xsl:value-of select="LOCATION_ID"/></td>
<td>

<table border="0" bgcolor="#85C2FF">
<xsl:for-each select="./EMP_DETAILS/EMP">
<tr bgcolor="#CEE7FF">
<td><xsl:value-of select="EMPLOYEE_ID"/></td>
<td><xsl:value-of select="FIRST_NAME"/></td>
<td><xsl:value-of select="LAST_NAME"/></td>
<td><xsl:value-of select="EMAIL"/></td>
<td><xsl:value-of select="PHONE_NUMBER"/></td>
<td><xsl:value-of select="HIRE_DATE"/></td>
<td><xsl:value-of select="JOB_ID"/></td>
<td><xsl:value-of select="SALARY"/></td>
<td><xsl:value-of select="MANAGER_ID"/></td>
</tr>
</xsl:for-each>
</table>

</td>
</tr>
</xsl:for-each>
</table>
<br />
</center>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

----------------------------------------------------------------------------------------------------

I then edited deptXML.xml which I created during my previous post and added an additional line (Second Line) to refer the above style sheet.

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

----------------------------------------------------------------------------------------------------

Now the browser displays the data in a more readable format.

than before

Department Id

Employees

10

Jennifer

20

Michael,Pat

30

Alexander,Den,Guy,Karen,Shelli,Sigal

40

Susan

50

Adam,Alana,Alexis,Anthony,Britney,Curtis,Donald,Douglas,Girard,Hazel,Irene,James,James,Jason,Jean,Jennifer,John,Joshua,Julia,Julia,Kelly,Kevin,Kevin,Ki,Laura,Martha,Matthew,Michael,Mozhe,Nandita,Payam,Peter,Randall,Randall,Renske,Samuel,Sarah,Shanta,Stephen,Steven,TJ,Timothy,Trenna,Vance,Winston

60

Alexander,Bruce,David,Diana,Valli

70

Hermann

80

Alberto,Allan,Alyssa,Amit,Charles,Christopher,Clara,Danielle,David,David,Eleni,Elizabeth,Ellen,Gerald,Harrison,Jack,Janette,John,Jonathon,Karen,Lindsey,Lisa,Louise,Mattea,Nanette,Oliver,Patrick,Peter,Peter,Sarath,Sundar,Sundita,Tayler,William

90

Lex,Neena,Steven

100

Daniel,Ismael,John,Jose Manuel,Luis,Nancy

110

Shelley,William

Kimberely

Alberto,Allan,Alyssa,Amit,Charles,Christopher,Clara,
Danielle,David,David,Eleni,Elizabeth,Ellen,Gerald,Harrison,
Jack,Janette,John,Jonathon,Karen,Lindsey,Lisa,Louise,Mattea,
Nanette,Oliver,Patrick,Peter,Peter,Sarath,Sundar,Sundita,Tayler,
William