gistfile1.sql

SELECT lines.lineitem, lines.description, lines.partid,
lines.unitprice, lines.quantity
FROM purchaseorder,
XMLTable('for $i in /PurchaseOrder/LineItems/LineItem
        where $i/@ItemNumber >= 8
         and $i/Part/@UnitPrice > 50
         and $i/Part/@Quantity > 2
        return $i'
      PASSING OBJECT_VALUE
      COLUMNS lineitem NUMBER PATH '@ItemNumber',
              description VARCHAR2(30) PATH 'Description',
              partid NUMBER PATH 'Part/@Id',
              unitprice NUMBER PATH 'Part/@UnitPrice', 
              quantity NUMBER PATH 'Part/@Quantity') 
lines;