In this example, the XPath expression (in bold) is extracting the Address elements in the XML documents for the customer named John Hancock.
SELECT customerXML.XMLEXTRACT('/Customer[Name="John Hancock"]/Address', '')
FROM customer
WHERE customerID = 1;
Query result:
customerXML.XMLEXTRACT('/Customer[Name="John Hancock"]/Address', '') -------------------------------------------------------------------- <Address>100 1st Street, San Francisco, CA 94118</Address>