REGEXP_REPLACE

This function allows you to replace a sequence of characters in a string with another set of characters using regular expression pattern matching.

Syntax

REGEXP_REPLACE( string, pattern [, replacement_string [, start_position [, nth_appearance [, match_parameter ] ] ] ] )