This chapter illustrated the techniques to produce XML from various data sources in Oracle Database 10g. We showed how to create XMLTypes from SQL data and how to extract, transform, aggregate, and concatenate XML data within SQL commands or PL/SQL programs.
This functionality, natively provided in Oracle Database 10g, permits a single source of data to be presented in multiple XML formats appropriate to individual clients or applications. This opens up information-sharing possibilities, resulting in better web publishing and data exchange across applications.