Summary
The chapter discusses various XML storage options and the associated data loading strategies in Oracle Database 10g. Table 9-1 shows the relationships between the XML storage and the functionality offered in the XML data-loading utilities. You can choose one of these utilities or use the SQL and PL/SQL interfaces to load XML documents into the Oracle database.
Utilities | Functionality | Relational Storage with XMLType Views | XMLType Tables | XMLType Columns |
---|---|---|---|---|
SQL*Loader | Command-line utility | Limited support | Yes | Yes |
XML SQL Utility | Command-line utility and programmatic interfaces in Java and PL/SQL | Yes | Yes | Yes |
TransX Utility | Command-line utility and programmatic interfaces in Java | Yes | Yes | Yes |
XSQL Servlet | Command-line utility, program interfaces in Java and the HTTP interfaces provided in the built-in action handlers | Yes | Yes | Yes |
HTTP/WebDAV | HTTP/WebDAV folders | No | Yes, but the table has to be the default table created during the XML schema registration. | No |
FTP Interfaces | FTP interfaces | No | Yes, but the table has to be the default table created during the XML schema registration. | No |