
【国外标准】 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 D5051-06(2021)e1 Standard Test Method for Rubber Compounding Materials—Benzothiazyl Disulfide (MBTS)—Assay
- ASTM D5055-19e1 Standard Specification for Establishing and Monitoring Structural Capacities of Prefabricated Wood I-Joists
- ASTM D5175-91(2017)e1 Standard Test Method for Organohalide Pesticides and Polychlorinated Biphenyls in Water by Microextraction and Gas Chromatography
- ASTM D5334-22ae1 Standard Test Method for Determination of Thermal Conductivity of Soil and Rock by Thermal Needle Probe Procedure
- ASTM D5379/D5379M-19e1 Standard Test Method for Shear Properties of Composite Materials by the V-Notched Beam Method
- ASTM D5412-93(2017)e1 Standard Test Method for Quantification of Complex Polycyclic Aromatic Hydrocarbon Mixtures or Petroleum Oils in Water
- ASTM D5456-21e1 Standard Specification for Evaluation of Structural Composite Lumber Products
- ASTM D5579-19e1 Standard Test Method for Evaluating the Thermal Stability of Manual Transmission Lubricants in a Cyclic Durability Test
- ASTM D5581-07A(2021)e1 Standard Test Method for Resistance to Plastic Flow of Bituminous Mixtures Using Marshall Apparatus (6 in. Diameter Specimen)
- ASTM D5703-95(2022)e1 Standard Practice for Preparatory Surface Cleaning for Clay Brick Masonry
- ASTM D5708-15(2020)e1 Standard Test Methods for Determination of Nickel, Vanadium, and Iron in Crude Oils and Residual Fuels by Inductively Coupled Plasma (ICP) Atomic Emission Spectrometry
- ASTM D5896-96(2019)e1 Standard Test Method for Carbohydrate Distribution of Cellulosic Materials
- ASTM D6017-97(2020)e1 Standard Test Method for Determination of Magnesium Sulfate (Epsom Salt) in Leather
- ASTM D6104-97(2017)e1 Standard Practice for Determining the Performance of Oil/Water Separators Subjected to Surface Run-Off
- ASTM D6134/D6134M-07(2019)e1 Standard Specification for Vulcanized Rubber Sheets Used in Waterproofing Systems