UNLIMITED FREE ACCESS TO THE WORLD'S BEST IDEAS

close
Already an Engineering360 user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your Engineering360 Experience

close
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Webinars & White Papers

ISO/IEC DIS 19075-1

Information technology — Guidance for the use of database language SQL — Part 1: XQuery regular expressions

active, Most Current
Buy Now
Organization: ISO
Publication Date: 3 June 2020
Status: active
Page Count: 30
ICS Code (Languages used in information technology): 35.060
scope:

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 Āve 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.

Document History

ISO/IEC DIS 19075-1
June 3, 2020
Information technology — Guidance for the use of database language SQL — Part 1: XQuery regular expressions
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....
July 15, 2011
Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL
This Technical Report describes the regular expression support in SQL adopted from the regular expression syntax of [XQuery F&O], which is derived from Perl. This Technical Report discusses five...

References

Advertisement