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