Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)

Part Number A86030-01


Solution Area




Introduction to Oracle XML, 20 of 27

Generating and Storing XML Documents

If the XML document has a well-defined structure and contains data that is updateable or used in other ways, the document is data-centric. Typically, the XML document contains elements or attributes that have complex structures.

Generated XML Examples




XML-SQL Utility (XSU) provides the means to then store an XML document by mapping it to the underlying object-relational storage, and conversely, provides the ability retrieve the object-relational data as an XML document.

When the XML Document Structure Needs Transforming


Combining XML Documents and Data Using Views


Views enable you to construct an object on the "fly" by combining XML data stored in a variety of ways. You can do the following:

When you need to retrieve the data as a whole, simply construct the structure from the various pieces of data with the use of type constructors in the view's select statement. XML-SQL Utility then enables retrieving the constructed data from the view as a single XML document.

How to Generate a Web Form's Infrastructure

To generate a web form's infrastructure, you can do the following:

  1. Use XML-SQL Utility to generate a DTD based on the schema of the underlying table being queried.


  3. Write Java code that use these classes to generate the infrastructure behind a web-based form.

  4. Based on this infrastructure, the web form can capture user data and create an XML document compatible with the database schema.


XML-SQL Utility Storage

Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.


Solution Area