Suppose we have the
following database:
Exchange Rate DB
| current_date | sourceCurrency | targetCurrency | exchangeRate |
| Aug 26 10:41:52 EDT 1999 | CAD | USD | 0.665572 |
| Aug 26 10:41:52 EDT 1999 | USD | CAD | 1.50244 |
| Aug 26 10:41:52 EDT 1999 | CAD | EUR | 0.638588 |
| Aug 26 10:41:52 EDT 1999 | EUR | CAD | 1.56601 |
| Aug 26 10:41:52 EDT 1999 | USD | EUR | 1.04229 |
| Aug 26 10:41:52 EDT 1999 | EUR | USD | 0.959446 |
The output of the query would contain the date,
source currency, target currency and exchange rate (all as strings). Hence, the
output would be:
<OUTPUT name = "rateOfExchange">
<elementType id="current_date"> <string/>
</elementType>
<elementType id="sourceCurrency"> <string/>
</elementType>
<elementType id="targetCurrency"> <string/>
</elementType>
<elementType id="exchangeRate"> <string/>
</elementType>
<elementType id="rateOfExchange">
<element type="current_date" />
<element type="sourceCurrency"
/>
<element type="targetCurrency"
/>
<element type="exchangeRate" />
</elementType>
</OUTPUT>