Tiêu chuẩn quốc tế

• Số hiệu / Standard Number: ANSI INCITS/ISO/IEC TR 19075-1:2011
• Năm ban hành / Publication date: 2011
• Tình trạng / Status: A - Còn hiệu lực
• Tên tiếng Anh / Title in English: Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL (Technical Report)
• Số trang / Page: 36

Phạm vi áp dụng / Scope of standard

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