Example 8-3: Portfolio of quotes using multiple queries

<?xml version="1.0"?>
<client-portfolio connection="xmlbook" xmlns:xsql="urn:oracle-xsql">
  <xsql:query rowset-element="" row-element="">

    select to_char(sysdate,'DD-MON-YYYY') as "effective-date" from dual

  </xsql:query>
  <client>
    <info>
      <xsql:query rowset-element="" row-element="" id-attribute="" tag-case="lower">

       SELECT id, name, homeaddress, workaddress
         FROM clients
        WHERE id = {@id}

      </xsql:query>
    </info>
  </client>
  <xsql:query rowset-element="portfolio" row-element="quote" tag-case="lower" >

    SELECT q.symbol,
           q.price,
           q.change
      FROM quotes q, portfolio_stocks ps
     WHERE q.symbol = ps.symbol
    AND ps.owner = {@id}

 </xsql:query>
</client-portfolio>