Figure 5 Constructing XML
　

SELECT invoice::query('
    {-- XQuery program --}
    namespace inv="urn:www-develop-com:invoices"
    namespace pmt="urn:www-develop-com:payments"
    for $invitem in //inv:Invoice
    return
      <pmt:Payment>
        <pmt:InvoiceID> { data($invitem/inv:InvoiceID) } </pmt:InvoiceID>
        <pmt:CustomerName> { data($invitem/inv:CustomerName) }
            </pmt:CustomerName>
        <pmt:PayAmt> { data(sum($invitem/inv:LineItems/inv:LineItem/
            inv:Price)) }</pmt:PayAmt>
      </pmt:Payment>
  ') as xmldoc
  FROM xmlinvoice