Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Generate DTD from XML

Paul V.Aug 15 2019

DB: 12.1.0.2 (Not RAC)

OS: Linux, kernal 2.6.32

My database has a table with a CLOB column.  Each row contains one XML document within that CLOB column.  Below is an example of a very small document:

<?xml version="1.0"?>

<DOCUMENT structured-text="generic-5.0" VERSION="A">

<DOC_ID SEQUENCE="DOC_ID"/>

<DOC_DLU EXPRESSION="SYSDATE"/>

<DOC_DTG>20110525</DOC_DTG>

<DOC_OFFICE_LOCATION>Boston</DOC_OFFICE_LOCATION>

<BODY>

<GEN_SUBJECT>

  <DOCNAME>K5TTY5989J</DOCNAME>

  <GEN_SUBJECT>

    <FIRSTNAME>Sizzley</FIRSTNAME>

    <SURNAME>Costello</SURNAME>

    <DOB>19440606</DOB>

    <DOCNAME>K5TTY5989J</DOCNAME>

  </GEN_SUBJECT>

</GEN_SUBJECT>

</BODY>

</DOCUMENT>

Is there an Oracle function in which I could pass a series of these records and the function would generate a DTD for the set of documents?

Any hints or ideas greatly appreciated.

Comments

Post Details

Added on Aug 15 2019
0 comments
348 views