Vadivelan's Tech Blog: Creating a XML document for records in Departments and Employees Table and also creating a XSD document

CREATE TYPE EMP AS OBJECT
(
EMPLOYEE_ID NUMBER (6),
FIRST_NAME VARCHAR2 (20),
LAST_NAME VARCHAR2 (25),
EMAIL VARCHAR2 (25),
PHONE_NUMBER VARCHAR2 (20),
HIRE_DATE DATE,
JOB_ID VARCHAR2 (10),
SALARY NUMBER (8, 2),
MANAGER_ID NUMBER (6)
);

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

CREATE TYPE EMP_DETAIL AS TABLE OF EMP;

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

CREATE TYPE DEPT AS OBJECT
(
DEPARTMENT_ID NUMBER (4),
DEPARTMENT_NAME VARCHAR2 (30),
MANAGER_ID NUMBER (6),
LOCATION_ID NUMBER (4),
emp_details EMP_DETAIL
);

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

CREATE TYPE DEPTS AS TABLE OF DEPT;

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

SELECT SYS_XMLGEN (
CAST (
MULTISET (
SELECT department_id,
department_name,
Manager_id,
location_id,
CAST (
MULTISET (SELECT Employee_id,
first_name,
Last_name,
email,
phone_number,
hire_date,
job_id,
salary,
manager_id
FROM employees d
WHERE d.department_id = m.department_id) AS EMP_DETAIL)
FROM departments m) AS depts)).getClobVal ()
AS XML_QUERY
FROM DUAL;

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

<?xml version="1.0" encoding="UTF-8"?>
<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>

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

Copy the XML into the XSD generator and create the XSD document for this XML(I used the free tool provided by http://www.freeformatter.com/)

<?xml version="1.0" encoding="UTF-8"?>

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element name="ROW">

<xs:complexType>

<xs:sequence>

<xs:element name="DEPT" maxOccurs="unbounded" minOccurs="0">

<xs:complexType>

<xs:sequence>

<xs:element type="xs:short" name="DEPARTMENT_ID"/>

<xs:element type="xs:string" name="DEPARTMENT_NAME"/>

<xs:element type="xs:short" name="MANAGER_ID" minOccurs="0"/>

<xs:element type="xs:short" name="LOCATION_ID"/>

<xs:element name="EMP_DETAILS">

<xs:complexType mixed="true">

<xs:sequence>

<xs:element name="EMP" maxOccurs="unbounded" minOccurs="0">

<xs:complexType>

<xs:sequence>

<xs:element type="xs:short" name="EMPLOYEE_ID"/>

<xs:element type="xs:string" name="FIRST_NAME"/>

<xs:element type="xs:string" name="LAST_NAME"/>

<xs:element type="xs:string" name="EMAIL"/>

<xs:element type="xs:string" name="PHONE_NUMBER"/>

<xs:element type="xs:string" name="HIRE_DATE"/>

<xs:element type="xs:string" name="JOB_ID"/>

<xs:element type="xs:short" name="SALARY"/>

<xs:element type="xs:short" name="MANAGER_ID" minOccurs="0"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:schema>

Vadivelan's Tech Blog

Creating a XML document for records in Departments and Employees Table and also creating a XSD document

No comments:

Post a Comment