This discussion is archived
9 Replies Latest reply: Aug 13, 2013 12:30 PM by odie_63 RSS

xmlquery in oracle 11g

883125 Newbie
Currently Being Moderated

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?


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points