ISO/IEC TR 19075-1:2011 信息技术 数据库语言 SQL技术报告 第1部分：SQL中的XQuery规则表达支持

标准编号：ISO/IEC TR 19075-1:2011

中文名称：信息技术 数据库语言 SQL技术报告 第1部分：SQL中的XQuery规则表达支持

英文名称：Information technology — Database languages — SQL Technical Reports — Part 1: XQuery Regular Expression Support in SQL

发布日期：2011-07

标准范围

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.

标准预览图