How do I use XPath expressions when querying from a XML attribute in a Oracle database

Question

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 an XML element 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?

kjhughes · Accepted Answer · 2016-04-09 14:53:42Z

1

You can test the self:: axis to select multiple children of Book:

/Book/*[self::Title or self::Year]

answered Apr 9, 2016 at 14:53

kjhughes

113k31 gold badges198 silver badges276 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

wero · Accepted Answer · 2016-04-09 14:55:31Z

1

You can use a union:

/book/title | /book/year

answered Apr 9, 2016 at 14:55

wero

33.1k3 gold badges63 silver badges87 bronze badges

Collectives™ on Stack Overflow

How do I use XPath expressions when querying from a XML attribute in a Oracle database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related