| 18. 4. 1. Regexp_Replace returns the source_string with every occurrence of the pattern_to_find replaced with the replace_string |
|
|
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>
|
|