
【国外标准】 Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL
本网站 发布时间:
2024-08-08
开通会员免费在线看70000余条国内标准,赠送文本下载次数,单本最低仅合13.3元!还可享标准出版进度查询、定制跟踪推送、标准查新等超多特权!  
查看详情>>

适用范围:
ISO/IEC TR 19075-1:2011 describes the regular expression support in SQL adopted from the regular expression syntax of XQuery 1.0 and XPath 2.0 Functions and Operators (Second Edition), which is derived from Perl. It 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.
标准号:
ANSI/INCITS/ISO/IEC TR 19075-1:2011[2015]
标准名称:
Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL
英文名称:
Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL标准状态:
现行-
发布日期:
-
实施日期:
出版语种:
- 推荐标准
- ASTM A876-17e1 Standard Specification for Flat-Rolled, Grain-Oriented, Silicon-Iron, Electrical Steel, Fully Processed Types
- ASTM B1-13(2018) Standard Specification for Hard-Drawn Copper Wire
- ASTM B197/B197M-20e1 Standard Specification for Copper-Beryllium Alloy Wire
- ASTM B254-92(2020)e1 Standard Practice for Preparation of and Electroplating on Stainless Steel
- ASTM B281-88(2019)e1 Standard Practice for Preparation of Copper and Copper-Base Alloys for Electroplating and Conversion Coatings
- ASTM B33-10(2020)e1 Standard Specification for Tin-Coated Soft or Annealed Copper Wire for Electrical Purposes
- ASTM B48-00(2021)e1 Standard Specification for Soft Rectangular and Square Bare Copper Wire for Electrical Conductors
- ASTM B499-09(2021)e1 Standard Test Method for Measurement of Coating Thicknesses by the Magnetic Method: Nonmagnetic Coatings on Magnetic Basis Metals
- ASTM B594-19e1 Standard Practice for Ultrasonic Inspection of Aluminum-Alloy Wrought Products
- ASTM B618/B618M-18e1 Standard Specification for Aluminum-Alloy Investment Castings
- ASTM B701/B701M-22e1 Standard Specification for Concentric-Lay-Stranded Self-Damping Aluminum Conductors, Steel Reinforced (ACSR/SD)
- ASTM B746/B746M-22e1 Standard Specification for Corrugated Aluminum Alloy Structural Plate for Field-Bolted Pipe, Pipe-Arches, and Arches
- ASTM B784-01(2017)e1 Standard Specification for Modified Concentric-Lay-Stranded Copper Conductors for Use in Insulated Electrical Cables
- ASTM B843-18e1 Standard Specification for Magnesium Alloy Anodes for Cathodic Protection
- ASTM B9-76(2017)e1 Standard Specification for Bronze Trolley Wire