Emp record

A record from an employee database. This is the classic example database from Oracle training known as SCOTT/TIGER

XQuery

 <Emp>
        <EmpNo>7369</EmpNo>
        <Ename>SMITH</Ename>
        <Job>CLERK</Job>
        <MgrNo>7902</MgrNo>
        <HireDate>1993-06-13</HireDate>
        <Sal>800</Sal>
        <Comm>0</Comm>
        <DeptNo>20</DeptNo>
 </Emp>

Result

<Emp>
    <EmpNo>7369</EmpNo>
    <Ename>SMITH</Ename>
    <Job>CLERK</Job>
    <MgrNo>7902</MgrNo>
    <HireDate>1993-06-13</HireDate>
    <Sal>800</Sal>
    <Comm>0</Comm>
    <DeptNo>20</DeptNo>
</Emp>