^ and $ mark the beginning and end of the entire subject).Įxtracts sub-matches applies only to REGEXP_INSTR, REGEXP_SUBSTR, REGEXP_SUBSTR_ALL, and the aliases for these functions.Įnables the POSIX wildcard character. By default, multi-line mode is disabled (i.e. meta-characters ^ and $ mark the beginning and end of any line of the subject). The following parameters are supported:Įnables multi-line mode (i.e. The parameters argument is a VARCHAR string that specifies the matchingīehavior of the regular expression function. Most regular expression functions support an optional parameters argument as the very last input. Specifying the Parameters for the Regular Expression ¶
Also, for functions that take or return subject offsets, a single Unicode character counts as 1. Regardless of the byte-length of the corresponding binary representation of that character. A single Unicode character always counts as one character (i.e. with (.|\n) in the pattern argument, or use the s parameter in the parameters argument (describedĪll the regular expression functions support Unicode. To also match newline characters, either replace. (in the pattern) does not include newline characters \n (in the subject) as matches. Pairs of dollar signs ($$) (rather than single quotes).īy default, the POSIX wildcard character. You do not need to escape backslashes if you are delimiting the string with Specifying Regular Expressions in Single-Quoted String Constants (in this topic). In single-quoted string constants, you must escape the backslash character in