If omitted, it defaults to 1 which is the first appearance of pattern in string. It is the nth appearance of pattern in string. If omitted, it defaults to 1 which is the first position in the string. It is the position in string where the search will start. If the replacement_string parameter is omitted, the function simply removes all matched patterns, and returns the resulting string. Matched patterns will be replaced with replacement_string in string. Matches the preceding pattern at least n times, but not more than m times. Matches the preceding pattern at least n times. Matches the preceding pattern zero or one occurrence. Matches the preceding pattern one or more occurrences. Matches the preceding pattern zero or more occurrences. Matches the beginning of a string or matches at the end of a string before a newline character. Matches one collation element that can be more than one character. Matches the nth subexpression found within ( ) before encountering . Matches at least m times, but no more than n times. Used to group expressions as a subexpression. Used to specify a nonmatching list where you are trying to match any character except for the ones in the list. Used to specify a matching list where you are trying to match any one of the characters in the list. Used like an 'OR' to specify more than one alternative. If used with a match_parameter of 'm', it matches the end of a line anywhere within expression.

If used with a match_parameter of 'm', it matches the start of a line anywhere within expression. It can be a combination of the following: Value The regular expression matching information. It can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The syntax for the REGEXP_REPLACE function in Oracle is: REGEXP_REPLACE( string, pattern ] ] ] ) Parameters or Arguments string The string to search.

Pick a number between 1 and 3 quote