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 |