The following query:
SELECT REGEXP_REPLACE('Hello Santa says ho ho', 'ho', 'HO!', 1, 2, 'c');
returns the result 'Hello Santa says ho HO!'.
The following query:
SELECT REGEXP_REPLACE('Hello Santa says ho ho', 'ho', 'HO!', 1, 2, 'c');
returns the result 'Hello Santa says ho HO!'.