To simplify the examples included in this chapter they use a subset of the Oracle Text options and make the following assumptions: Oracle Text can also deal with documents in a file system or in URLs, but we are not considering these document types in this chapter. XML text is aVARCHAR2 or CLOB type in an Oracle 9i database table with character semantics. You can find more examples for Oracle Text and for creating section group indexes at the following site: Assumptions Made in This Chapter's Examples You can now perform Oracle Text searches on tables containing XMLType columns. The schema objects are present when you perform an Oracle9 i installation. These objects are linked to the Oracle kernel. Oracle Text is essentially a set of schema objects owned by CTXSYS. No special installation instructions are required. It needs to be selected during installation. Oracle Text is a standard feature that comes with every Oracle 9i Standard, Enterprise, and Personal edition license.
This chapter explains the use of Oracle Text functionality in indexing and querying XML data.