As the amount of text in your database increases, so does the complexity of the text queries performed against the database. Instead of simply performing string matches, you’ll need new text-search features—such as weighting the terms in a search of multiple terms or ranking the results of a text search.
You can use Oracle Text to perform text-based searches. Text-searching capabilities include wildcard searching, “fuzzy matches,” relevance ranking, proximity searching, term weighting, and word expansions. In this chapter, you’ll see how to configure and use Oracle Text.