O'Reilly logo

Oracle Database 12c The Complete Reference by Bob Bryla, Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required