🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 19075-1:2021

BS ISO/IEC 19075-1:2021

$167.15

Information technology. Guidance for the use of database language SQL – XQuery regular expressions

Published By Publication Date Number of Pages
BSI 2021 36
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

This document describes the regular expression support in SQL (ISO/IEC 9075‑2) 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:

  • LIKE_REGEX predicate, to determine the existence of a match to a regular expression.

  • OCCURRENCES_REGEX numeric function, to determine the number of matches to a regular expression.

  • POSITION_REGEX function, to determine the position of a match.

  • SUBSTRING_REGEX function, to extract a substring matching a regular expression.

  • TRANSLATE_REGEX function, to perform replacements using a regular expression.

PDF Catalog

PDF Pages PDF Title
2 undefined
5 Contents
6 Tables
9 Introduction
11 1 Scope
12 2 Normative references
13 3 Terms and definitions
14 4 XQuery regular expressions
4.1 Context of XQuery regular expressions
4.2 Introduction to XQuery regular expressions
4.3 Matching a specific character
15 4.4 Metacharacters and escape sequences
16 4.5 Dot
17 4.6 Anchors
4.7 Line terminators
18 4.8 Bracket expressions
4.8.1 Introduction to bracket expressions
4.8.2 Listing characters
19 4.8.3 Matching a range
4.8.4 Negation
4.8.5 Character class subtraction
4.9 Alternation
20 4.10 Quantifiers
21 4.11 Locating a match
22 4.12 Capture and back-reference
23 4.13 Precedence
4.14 Modes
25 5 Operators using regular expressions
5.1 Introduction to operators using regular expressions
5.2 LIKE_REGEX
26 5.3 OCCURRENCES_REGEX
27 5.4 POSITION_REGEX
29 5.5 SUBSTRING_REGEX
30 5.6 TRANSLATE_REGEX

Related products

BS ISO/IEC 19075-1:2021
$167.15