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

CHAPTER8Searching for Regular Expressions

The SUBSTR, INSTR, LIKE, REPLACE, and COUNT functions have been enhanced and extended to support searches for Unix-like regular expressions. Regular expressions support a wide array of standardized controls and checks—for example, matching values a specific number of times, searches for punctuation characters, or searches for digits. You can use these new functions to perform advanced searches against strings. These functions, introduced in Oracle Database 10g, are named REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_LIKE, REGEXP_REPLACE, and REGEXP_COUNT.

NOTE

Users who have previously used the Unix grep command ...

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