Example: extracting the book title from the XML documents

select filename, xmlextract("//book/title" , content)
from xmlxfsTab
filename
-------------------------------------------------
bookstore.1.xml
<title>Seven Years in Trenton</title>
bookstore.2.xml
<title>Modern Database Management</title>

(2 rows affected)