image

CHAPTER27Using Oracle Text for Text Searches

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.

Adding Text to the Database ...

Get Oracle Database 12c The Complete Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.