See the Oracle Database SQL Reference for syntax details on the REGEXP_LIKE function. Use this function in the WHERE clause of a query to return rows matching the regular expression you specify. This function searches a character column for a pattern. Table 12-1 SQL Regular Expression Functions SQL Function If your regular expression includes the single quote character, enter two single quotation marks to represent one single quotation mark within your expression. Īs with all text literals used in SQL functions, regular expressions must be enclosed or wrapped between single quotes. The behavior of supported metacharacters and related features is described in 'Metacharacters Supported in Regular Expressions'. Oracle Database supports a set of common metacharacters used in regular expressions. See 'Oracle Database SQL Functions for Regular Expressions' later in this chapter for more information. You can use these functions in any environment where Oracle Database SQL is used.

Regular expression support is implemented with a set of Oracle Database SQL functions that allow you to search and manipulate string data. Oracle Database implements regular expression support compliant with the POSIX Extended Regular Expression (ERE) specification.

Oracle Database Regular Expression Support

Literals-the actual characters to search for.Įxamples of regular expression syntax are given later in this chapter.

Metacharacters-operators that specify algorithms for performing the search.

This regular expression matches both 'abd' and 'acd'.Ī regular expression is specified using two types of characters: Searches for the pattern: 'a', followed by either 'b' or 'c', then followed by 'd'. For example, the following regular expression: a(b|c)d

A regular expression can specify complex patterns of character sequences. Regular expressions specify patterns to search for in string data using standardized syntax conventions.

Mastering Regular Expressions published by O'Reilly & Associates, Inc.

Oracle Database Globalization Support Guide for details on using SQL regular expression functions in a multilingual environment.

Oracle Database SQL Reference for additional details on Oracle Database SQL functions for regular expressions.

Posix regular expression not match