RE: SQL XML Question

Steve

> Third (doesn't return author, firstname or ISBN)?

Two problems here...

1. the XPath expression '/bookcatalog/book/title/firstname' is wrong. You should use '/bookcatalog/book/author/firstname'.
2. extractValue cannot be used with an expression like '/bookcatalog/book/title/author' because it contains sub-nodes.

> Fourth (Returns incorrect value from the existsNode function)?

The XPath expression '/bookcatalog/book/title[QUERY="History of Interviews"]' should be '/bookcatalog/book/title[text()="History of Interviews"]'.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l