<?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> |