regexp_replace()

Let us now check the regexp_replace(string text, pattern text, replacement text) function with the following query.

Query

default> select regexp_replace('abcdef', '(ˆab|ef$)', ‘–‘);

Result

The above query will generate the following result.

–cd– 

The query replaces the substrings matched to a given regular expression pattern.