This document describes the regular expression support in SQL (ISO\/IEC 9075\u20112) adopted from the regular expression syntax of XQuery and XPath Functions and Operators 3.1, which is derived from Perl. This document discusses five operators using this regular expression syntax:<\/p>\n
LIKE_REGEX predicate, to determine the existence of a match to a regular expression.<\/p>\n<\/li>\n
OCCURRENCES_REGEX numeric function, to determine the number of matches to a regular expression.<\/p>\n<\/li>\n
POSITION_REGEX function, to determine the position of a match.<\/p>\n<\/li>\n
SUBSTRING_REGEX function, to extract a substring matching a regular expression.<\/p>\n<\/li>\n
TRANSLATE_REGEX function, to perform replacements using a regular expression.<\/p>\n<\/li>\n<\/ul>\n
| PDF Pages<\/th>\n | PDF Title<\/th>\n<\/tr>\n | ||||||
|---|---|---|---|---|---|---|---|
| 2<\/td>\n | undefined <\/td>\n<\/tr>\n | ||||||
| 5<\/td>\n | Contents <\/td>\n<\/tr>\n | ||||||
| 6<\/td>\n | Tables <\/td>\n<\/tr>\n | ||||||
| 9<\/td>\n | Introduction <\/td>\n<\/tr>\n | ||||||
| 11<\/td>\n | 1 Scope <\/td>\n<\/tr>\n | ||||||
| 12<\/td>\n | 2 Normative references <\/td>\n<\/tr>\n | ||||||
| 13<\/td>\n | 3 Terms and definitions <\/td>\n<\/tr>\n | ||||||
| 14<\/td>\n | 4 XQuery regular expressions 4.1 Context of XQuery regular expressions 4.2 Introduction to XQuery regular expressions 4.3 Matching a specific character <\/td>\n<\/tr>\n | ||||||
| 15<\/td>\n | 4.4 Metacharacters and escape sequences <\/td>\n<\/tr>\n | ||||||
| 16<\/td>\n | 4.5 Dot <\/td>\n<\/tr>\n | ||||||
| 17<\/td>\n | 4.6 Anchors 4.7 Line terminators <\/td>\n<\/tr>\n | ||||||
| 18<\/td>\n | 4.8 Bracket expressions 4.8.1 Introduction to bracket expressions 4.8.2 Listing characters <\/td>\n<\/tr>\n | ||||||
| 19<\/td>\n | 4.8.3 Matching a range 4.8.4 Negation 4.8.5 Character class subtraction 4.9 Alternation <\/td>\n<\/tr>\n | ||||||
| 20<\/td>\n | 4.10 Quantifiers <\/td>\n<\/tr>\n | ||||||
| 21<\/td>\n | 4.11 Locating a match <\/td>\n<\/tr>\n | ||||||
| 22<\/td>\n | 4.12 Capture and back-reference <\/td>\n<\/tr>\n | ||||||
| 23<\/td>\n | 4.13 Precedence 4.14 Modes <\/td>\n<\/tr>\n | ||||||
| 25<\/td>\n | 5 Operators using regular expressions 5.1 Introduction to operators using regular expressions 5.2 LIKE_REGEX <\/td>\n<\/tr>\n | ||||||
| 26<\/td>\n | 5.3 OCCURRENCES_REGEX <\/td>\n<\/tr>\n | ||||||
| 27<\/td>\n | 5.4 POSITION_REGEX <\/td>\n<\/tr>\n | ||||||
| 29<\/td>\n | 5.5 SUBSTRING_REGEX <\/td>\n<\/tr>\n | ||||||
| 30<\/td>\n | 5.6 TRANSLATE_REGEX <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Information technology. Guidance for the use of database language SQL – XQuery regular expressions<\/b><\/p>\n |