How Can I Search Different XML Documents Stored in CLOBs With Different DTDs?
If I store XML in CLOBs and use the DOM or SAX to reparse the XML later as needed.How can I search this document repository? Oracle Text (intermedia Text) seems ideal. Do you have an example of setting this up using intermedia in Oracle8i, demonstrating how to define the XML_SECTION_GROUP and where to use a ZONE as opposed to a FIELD, and so on? For example: How would I define Intermedia parameters so that I would be able to search my CLOB column for records that had the “aorta” and “damage” in the using the following XML (DTD implied) WellKnownFileName.gif echo cardiogram aorta This is an image of the vessel damage. Answer Oracle8i Release 2 (8.1.6) and higher allow searching within attribute text. That’s something like: state within book@author. Oracle now offers attribute value sensitive search, more like the following: state within book[@author = “Eric”]: begin ctx_ddl.create_section_group(‘mygrp’,’basic_section_group’); ctx_ddl.add_field_section(‘mygrp’,’keyword’,’keyword’); ctx_d
Question If I store XML in CLOBs and use the DOM or SAX to reparse the XML later as needed.How can I search this document repository? Oracle Text (intermedia Text) seems ideal. Do you have an example of setting this up using intermedia in Oracle8i, demonstrating how to define the XML_SECTION_GROUP and where to use a ZONE as opposed to a FIELD, and so on? For example: How would I define Intermedia parameters so that I would be able to search my CLOB column for records that had the “aorta” and “damage” in the using the following XML (DTD implied) WellKnownFileName.gif echo cardiogram aorta This is an image of the vessel damage. Question Oracle8i Release 2 (8.1.6) and higher allow searching within attribute text. That’s something like: state within book@author. Oracle now offers attribute value sensitive search, more like the following: state within book[@author = “Eric”]: begin ctx_ddl.create_section_group(‘mygrp’,’basic_section_group’); ctx_ddl.add_field_section(‘mygrp’,’keyword’,’keywo
