Example of XPath expressions

The input consists of addresses and orders for customers. The address data is grouped using the root element /addresses. The order data is grouped using the root element /orders.

Using the root element to group related data, such as address data

The ADDRESSES column receives the following XML structures:

<addresses>
   <address street=" " city=" ">
   ...
</addresses>

The ORDERS column receives the following XML structures:

<orders>
   <order id=" ">
      <order item=" ">
      ...
</orders>