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;