xpath « XML « Oracle PL / SQL

1.Use extract function and xpath function to retrieve xml element data
2.Use extract function to get xmltype data
3.XPath text() function
4.Oracle support XPath predicate expressions
5.Use the EXTRACT function and the following XPath:/emps/emp/interests/interest/
6.extract(doc, '/message/greeting/text()')
7.Extract returns a COLLECTION of values (a repeating node)
8.Find rows that contain the ROWSET/ROW node