
【国外标准】 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 D2574-16(2020)e1 Standard Test Method for Resistance of Emulsion Paints in the Container to Attack by Microorganisms
- ASTM D2672-20e1 Standard Specification for Joints for IPS PVC Pipe Using Solvent Cement
- ASTM D2844/D2844M-18e1 Standard Test Method for Resistance R-Value and Expansion Pressure of Compacted Soils
- ASTM D3172-13(2021)e1 Standard Practice for Proximate Analysis of Coal and Coke
- ASTM D3174-12(2018)e1 Standard Test Method for Ash in the Analysis Sample of Coal and Coke from Coal
- ASTM D3241-23ae1 Standard Test Method for Thermal Oxidation Stability of Aviation Turbine Fuels
- ASTM D346/D346M-11(2019)e1 Standard Practice for Collection and Preparation of Coke Samples for Laboratory Analysis
- ASTM D3516-89(2019)e1 Standard Test Methods for Ashing Cellulose
- ASTM D3554-20e1 Standard Specification for Track-Resistant Thermoplastic High-Density Polyethylene Insulation for Wire and Cable, 75 °C Operation
- ASTM D3561-16(2021)e1 Standard Test Method for Lithium, Potassium, and Sodium Ions in Brackish Water, Seawater, and Brines by Atomic Absorption Spectrophotometry
- ASTM D3597-02(2018)e1 Standard Performance Specification for Woven Upholstery Fabrics—Plain, Tufted, or Flocked
- ASTM D3695-95(2021)e1 Standard Test Method for Volatile Alcohols in Water by Direct Aqueous-Injection Gas Chromatography
- ASTM D3843-16(2021)e1 Standard Practice for Quality Assurance for Protective Coatings Applied to Nuclear Facilities
- ASTM D3885-07A(2019)e1 Standard Test Method for Abrasion Resistance of Textile Fabrics (Flexing and Abrasion Method)
- ASTM D3972-09(2015) Standard Test Method for Isotopic Uranium in Water by Radiochemistry