BS ISO/IEC 19075-1:2021
Current
The latest, up-to-date edition.
Information technology. Guidance for the use of database language SQL XQuery regular expressions
Hardcopy , PDF
English
08-09-2021
| Committee |
IST/40
|
| DocumentType |
Standard
|
| ISBN |
9780539130782
|
| Pages |
36
|
| PublisherName |
British Standards Institution
|
| Status |
Current
|
| Supersedes |
This document describes the regular expression support in SQL (ISO/IEC9075‑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.
| Standards | Relationship |
| ISO/IEC 19075-1:2021 | Equivalent |
Please Login or Create an Account so you can add users to your Multi user PDF Later.
Important note : All end users must be registered with an Account prior to user licenses being assigned.
Users cannot be edited or removed once added to your Multi user PDF.