Combining Oracle Text Features with Oracle XML DB (XML Search Index)

When you want a full-text retrieval for applications, combine the features of Oracle Text and Oracle XML DB to create an XML Search Index. In this case, leverage the XML structure by entering queries such as “find all nodes that contain the word Pentium.” Oracle Database 12c extends Oracle’s support for the W3C XQuery specification by adding support for the XQuery full-text extension. This support lets you perform XML-aware, full-text searches on XML content that is stored in the database.

The following topics explain how to use Oracle XML DB with Oracle Text applications:

• Using the xml_enable Method for an XML Search Index

• Using the Text-on-XML Method

• Indexing JSON Data

See Also:

• “XML Section Searching with Oracle Text”

• Oracle Text Reference for information about the xml_enable variable of SET_SEC_GRP_ATTR to enable XML awareness

• Oracle XML DB Developer’s Guide for more information about XML full-text indexing and XML Search Index