Example 10-11: Automatically producing stock quote XML with DBXML
CREATE PROCEDURE StockQuotesDbxmlBasic( id NUMBER ) IS
BEGIN
Dbxml.Query('SELECT q.symbol as Symbol,
q.price as Price,
q.change as Change
FROM quotes q, portfolio_stocks ps
WHERE q.symbol = ps.symbol
AND ps.owner = ' || id);
END;