
【国外标准】 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 C1702-23e1 Standard Test Method for Measurement of Heat of Hydration of Hydraulic Cementitious Materials Using Isothermal Conduction Calorimetry
- ASTM D2555-17a(2024)e1 Standard Practice for Establishing Clear Wood Strength Values
- ASTM D4439-24e1 Standard Terminology for Geosynthetics
- ASTM D6724/D6724M-16(2024)e1 Standard Guide for Installation of Direct Push Groundwater Monitoring Wells
- ASTM F2623-24e1 Standard Specification for Polyethylene of Raised Temperature (PE-RT) Systems for Non-Potable Water Applications
- BSR INCITS 437-200x Information technology - Fibre Channel - SATA Tunneling Protocol (FC-SATA) (Draft Standard)
- ASTM C1528/C1528M-20e1 Standard Guide for Selection of Dimension Stone
- ASTM C1582/C1582M-11(2017)e1 Standard Specification for Admixtures to Inhibit Chloride-Induced Corrosion of Reinforcing Steel in Concrete
- ASTM C1645-22ae1 Standard Test Method for Freeze-thaw and De-icing Salt Durability of Solid Concrete Interlocking Paving Units
- ASTM C1658/C1658M-19e1 Standard Specification for Glass Mat Gypsum Panels
- ASTM C177-19e1 Standard Test Method for Steady-State Heat Flux Measurements and Thermal Transmission Properties by Means of the Guarded-Hot-Plate Apparatus
- ASTM C1799/C1799M-22e1 Standard Guide to Dimension Stone Test Specimen Sampling and Preparation
- ASTM C1860-23ce1 Standard Test Methods for Measurement of Tensile Strength or Bond Strength of Portland Cement-Based Plaster by Direct Tension
- ASTM C1882/C1882M-24e1 Standard Specification for Anti-washout Admixtures for Concrete
- ASTM C1940-24e1 Standard Test Method for Critical Mode I Interlaminar Strain Energy Release Rate (GIc) of Continuous Fiber-Reinforced Advanced Ceramics at Ambient Temperatures