![]() ![]() ![]() \d can be used both inside and outside character classes, and is equivalent to ]. For example, the following statement searches Contacts.Phone for all phone numbers Matches a digit in the current collation. Used outside a character set to match the start of a string.Įquivalent to ^ used outside a character set. Matches the character whose value is \0 xxx, where xxx is any sequence of octal digits, and 0 is a zero. Regular expressions: Other supported syntax conventions Match a character that is in the character class. Match alphabetic, digit, or underscore characters in the current collation. Match one of: sub-character class may not include non-ASCII punctuation characters available in the current collation. Include newline, form feed, backspace, and so on. Match ASCII characters with an ordinal value of less than 32, or character value 127 (control characters). Match a blank space, or a horizontal tab. Match any seven-bit ASCII character (ordinal value between 0 and 127). Match a whitespace character such as space, tab, formfeed, and carriage return. For example, 'ab]' matches one of: any uppercase letter, a, or b. Match uppercase alphabetic characters in the current collation. For example, the following statement searches Contacts.City for any city with a two word name: For example, ']' does not match A because A is uppercase. Match lowercase alphabetic characters in the current collation. Likewise, '-] ' matches a string of one or more characters that are not digits or dashes. For example, '-] ' matches a string of one or more digits or dashes. For example, '] ' matches a string of one or more letters and numbers. Match digits, and upper- and lowercase alphabetic characters in the current collation. Metacharacters are handled as regular characters when positioned inside of a character class.įor SIMILAR TO (only), the metacharacters *, ?, , _, |, (, ), ' matches three digits, followed by two letters. Regular expression can vary depending on whether the metacharacter is placed inside a character class. A character class is a set of characters enclosed in square brackets, against which characters in a string are matched.įor example, in the syntax SIMILAR TO 'ab', is a character class and matches one digit in the range of 1 to 9, inclusive. Whether the metacharacter is inside of a character class in the regular expressionīefore continuing, you should understand the definition of a character class. Whether the regular expression is being used with the SIMILAR TO or REGEXP search conditions, or the REGEXP_SUBSTR function ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |