Oracle SQL * Loader可以处理XML吗? [英] Can Oracle SQL*Loader process XML?

问题描述

Oracle是否提供XML格式文件的标准化上传? 我认为用于XML输出的规范格式(结构= ROWSET/ROW/columname)可以通过仅运行带有适当控制文件内容的sqlldr再次上传回表中. 但是我在网上的任何地方都找不到关于此的任何信息，试验后的错误消息似乎表明只能将XML上载到XML类型的表中，我只想在纯表中上载数据但提供数据XML格式.

Does Oracle offer a standardized upload of XML formatted files? I thought that the canonical format that is used for XML output, structure = ROWSET/ROW/columname, could be uploaded back into the table again, by just running sqlldr with appropriate control file contents.
But I cannot find anything about this anywhere on the web, and error messages after trials seem to indicate that it is only possible to upload XML into XML-type formatted tables, where I just want to upload data in a plain table but supply the data in XML format.

推荐答案

否，SQL * Loader仅能处理平面"文件.

No, SQL*Loader can only process "flat" files.

一个选择是编写一个XSLT转换，该转换将ROWSET/ROW/column格式转换为文本文件，然后将其导入目标表.

One option is to write an XSLT transformation that turns the ROWSET/ROW/column format into a text file and then import that into the target table.

另一种选择是将XML导入一行，然后使用Oracle的XML函数从该登台表中选择一个关系结果并将其插入到真实表中.

Another option is to import the XML into a single row, and then use Oracle's XML functions to select a relational result from that staging table and insert it into the real table.

这篇关于Oracle SQL * Loader可以处理XML吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！