The parameters of a function call can be complex XPath expressions that include predicates. They can also be nested function calls:
select xmlextract
('//book[normalize-space(tolower(title))="seven years in trenton"]/author', text_doc)
from sample_docs where name_doc='bookstore'-----------------------------------------
<author>
<first-name>Joe</first-name>
<last-name>Bob</last-name>
<award>Trenton Literary Review
Honorable Mention</award>
</author>
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
