Oracle REGEXP Function: Guide & Examples

The regexp function in Oracle is used for performing regular expression matching operations. It takes two parameters: pattern and source. The pattern is a regular expression pattern that specifies the string pattern to match, while the source is the string on which the matching operation is to be performed.

The regexp function returns a number indicating the success of the match. It returns 1 if successful and 0 if not.

For example, the following statement will check if the source string contains the pattern specified:

Count the number of times ‘Hello’ appears in ‘Hello World’.

The result is 1, because the source string contains a substring “Hello”.

There are several variations of the regexp function, such as regexp_instr, regexp_replace, and regexp_substr, which are used for different regular expression operations.