XML : How do I use XPATH expressions when querying from a xml attribute in a Oracle database

I am using XPATH to query a database. I am having trouble trying to return two values. I have a single attribute table which is a XML attribute called BOOK. I could find the title of all books but i don't know how to find the title AND year of all books. Below shows BOOK:

  <Book>  <Title></Title>  <Year></Year>  <Author></Author>  </Book>    

To find the title of all books i would use:

  /book/title.    

How would i find the title and the year of all books?

No comments:

Post a Comment