Oracle Database 11g Building Oracle XML DB Applications

CHAPTER

10

Searching XML

With the significant growth of unstructured content over the past few years, full-text search becomes more important to ensure that database users can find information efficiently. In this chapter, we will learn how to enable full-text search on XML data stored in the Oracle database.

EXAMPLE SETUP

To run the examples in this chapter, you need to finish running the examples in Chapter 9 and then create a materialized view in the XMLDEMO user (create_mv.sql):

create materialized view po_mv AS

SELECT * FROM po_xquery_vw;

To refresh po_mv, you can use the DBMS_SNAPSHOT package to perform a COMPLETE refresh (refresh_mv.sql): ...