Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I Break up and Store an XML Document without a DDL Insert?

April 26, 2017break DDL DOCUMENT insert store XML

0

Posted

Can I Break up and Store an XML Document without a DDL Insert?

1 Answer

0

Posted

Question We would like to break apart an arbitrary XML document and store it in the database without creating a DDL to insert. Is this possible? And as for querying, is it possible to perform hierarchical searches across XML documents? Answer No this is not possible. Either the schema must already exist or and XSL stylesheet to create the DDL from the XML must exist. From Oracle8i Release 8.1.6 and higher, interMedia Text (now called Oracle Text) can do this.