Hi all,
I have xml in below format, How can I extract all the values in single query.
<records>
<job>MANAGER</job>
<details>
<ename>JONES</ename>
<sal>2975</sal>
<ename>BLAKE</ename>
<sal>2850</sal>
<ename>CLARK</ename>
<sal>2450</sal>
</details>
</records>
Thanks