CRITICAL SKILL 8.3
SQLX: Create XML from Data Stored in Oracle
For years, organizations have been pouring their data into relational databases. If you’re trading data with another organization, however, it’s likely that you’ll need to pull data out of your relational database and format that data as XML before transmitting it.
Let’s first point out that generating XML from a relational source is a not a trivial task. It involves understanding how to map relational data into a hierarchal structure. On the other hand, creating the XML once you understand the mapping you want has been made easy.
The SQL/XML Standard
Oracle Database 10g implements a number of standards-based functions enabling you to query relational data and return XML documents. ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
