9 Replies Latest reply on Aug 13, 2013 7:30 PM by odie_63

    xmlquery in oracle 11g




      I would like to use xmlquery instead of extractvalue as we are using oracle 11.2.

      I have the following xml from which I would like to extract the values of id and vendor using xml query

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

      <Order id="54321" vendor="ABCD"/>

      There is no other information in xml except for the root and it attributes.

      How can I do this?