The CONTAINS Operator with XML Search Applications

The CONTAINS operator is well suited to structured searching, enabling you to perform restrictive searches with the WITHIN, HASPATH, and INPATH operators. If you use a CONTEXT index, then you can also benefit from the following characteristics of Oracle Text searches:

• Token-based, whitespace-normalized searches

• Hitlists ranked by relevance

• Case-sensitive searching

• Section searching

• Linguistic features such as stemming and fuzzy searching

• Performance-optimized queries for large document sets

WARNING:

If you manually uninstall Oracle Text, then drop the DBMS_XDBT package. If you manually install Oracle Text, then create the DBMS_XDBT package.

Starting with Oracle Database 12c, Oracle XML Database (XML DB) is automatically installed when you install the new Oracle Database software or when you upgrade.

See Also: “XML Section Searching with Oracle Text”