Regexp_Replace returns the source_string with every occurrence of the pattern_to_find replaced with the replace_string : REGEXP_REPLACE « Regular Expressions Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Regular Expressions Functions
3. REGEXP_REPLACE

The simplest format for this function is:

REGEXP_REPLACE (source_string, pattern_to_find, pattern_to_replace_by)

The general format for the REGEXP_REPLACE function with all the options is:

REGEXP_REPLACE (source_string, pattern_to_find,[pattern_to_replace_by, position, occurrence,match_parameter])

SQL> SELECT REGEXP_REPLACE('Mississippi', 'si', 'SI', 1, 0, 'i')
  2  FROM dual;

REGEXP_REPL
-----------
MisSIsSIppi

SQL>