1 2 Previous Next 27 Replies Latest reply: Jul 17, 2014 7:16 AM by 994122 RSS

    How can I extract all the values in single query in the oracle xml

    994122

      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

        1 2 Previous Next