selecting the XML Node number

This question is regarding the xml node number.

 

We have defined a view to read the multiple level of XML data, using XMLTable function. How can we select the <employeeDetails> element number, for individual nodes of XML.

Sample xml is:

 

<EmployeeList>

                <EmployeeDetails>                                                                                -- This would be  node 1

                                <EmployeeFirstName>EmpF1</EmployeeFirstName>

                                <EmployeeLastName>EmpL1</EmployeeLastName>

                </EmployeeDetails>

                <EmployeeDetails>                                                                                -- This would be  node 2

                                <EmployeeFirstName>EmpF2</EmployeeFirstName>

                                <EmployeeLastName>EmpL2</EmployeeLastName>

                </EmployeeDetails>

                <EmployeeDetails>                                                                                -- This would be  node 3

                                <EmployeeFirstName>EmpF3</EmployeeFirstName>

                                <EmployeeLastName>EmpL3</EmployeeLastName>

                </EmployeeDetails>

                <EmployeeDetails>                                                                                 -- This would be  node 4

                                <EmployeeFirstName>EmpF4</EmployeeFirstName>

                                <EmployeeLastName>EmpL4</EmployeeLastName>

                </EmployeeDetails>

</EmployeeList>

 

 

Our relational view definition is:

CREATE