![oracle regular expression not like oracle regular expression not like](https://i.stack.imgur.com/MCSld.png)
Matches the specified character or group of characters at the beginning of a string (starts with search).Įxample: ^VISA matches strings beginning with VISA. (BER) is a capturing group and is allowed zero or one time. The regular expression does not match SSN.Īn example of regular expression using capturing group is SSN_NUM(BER)?, which matches SSN_NUM and SSN_NUMBER. Here, is a character class and is allowed one or more times. You can also use quantifiers with character classes and capturing groups.Īn example of regular expression using character class is SSN+, which matches strings like SSN0, SSN1, and SSN12.
![oracle regular expression not like oracle regular expression not like](https://i0.wp.com/www.complexsql.com/wp-content/uploads/2018/02/REGEX.jpg)
Matches the specified character or group of characters at least n times but not more than m times. Matches the specified character or group of characters at least n times.Įxample: 9 matches 999, 9999, and 99999, but not 99. Matches the specified character or group of characters exactly n times. Matches one or more occurrences of the specified character or group of characters.Įxample: TERM.+DATE matches strings like TERM_DATE and TERMINATION_DATE, but not TERMDATE. Matches zero or more occurrences of the specified character or group of characters.Įxample: TERM.*DATE matches strings like TERMDATE, TERM_DATE and LAST_TERMINATION_DATE. Matches zero or one occurrence of the specified character or group of characters.Įxample: SSN_NUMBERS? matches strings SSN_NUMBER and SSN_NUMBERS.