9 Replies Latest reply: Aug 13, 2013 2:30 PM by odie_63 RSS

    xmlquery in oracle 11g

    883125

      Hi,

       

      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?