REGEX and string manipulation with SQL

REGEXP_SUBSTR : search a string for a regular expression pattern


REGEXP_REPLACE the function returns source_char with every occurrence of the regular expression pattern replaced with replace_string

REPLACE REPLACE returns char with every occurrence of search_string replaced with replacement_string