image

CHAPTER7Getting Text Information and Changing It

This chapter introduces string functions, which are software tools that allow you to manipulate a string of letters or other characters. To reference individual functions quickly, look them up by name in the Alphabetical Reference section of this book. This chapter focuses on the manipulation of text strings; to perform word searches (including word stem expansions and fuzzy matches) you should use Oracle Text, as described in Chapter 27.

Functions in Oracle work in one of two ways. Some functions create new objects from old ones; they produce a result that is a modification of the original information, ...

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.