
【国外标准】 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 E223-23e1 Standard Test Methods for Analysis of Sulfuric Acid
- ASTM E2346/E2346M-15(2022)e1 Standard Guide for Sensory Evaluation of Household Hard Surface-Cleaning Products with Emphasis on Spray Triggers
- ASTM E2394-11(2020)e1 Standard Practice for Maintenance, Renovation, and Repair of Installed Asbestos Cement Products
- ASTM E2513-07(2019)e1 Standard Specification for Multi-Story Building External Evacuation Platform Rescue Systems
- ASTM E2554-18e1 Standard Practice for Estimating and Monitoring the Uncertainty of Test Results of a Test Method Using Control Chart Techniques
- ASTM E2555-21e1 Standard Practice for Factors and Procedures for Applying the MIL-STD-105 Plans in Life and Reliability Inspection
- ASTM E2784-10(2015) Standard Test Method for Evaluation of the Effectiveness of Handwash Formulations Using the Paper Towel (Palmar) Method of Hand Contamination
- ASTM E2916-19e1 Standard Terminology for Digital and Multimedia Evidence Examination
- ASTM E2953-14(2020)e1 Standard Specification for Evaluating Accelerated Aging Performance of Electrochromic Devices in Sealed Insulating Glass Units
- ASTM E3030-19e1 Standard Digital Reference Images for Heavy-Walled (2 to 412 in. (50.8 to 114 mm)) Steel Castings
- ASTM E354-21e1 Standard Test Methods for Chemical Analysis of High-Temperature, Electrical, Magnetic, and Other Similar Iron, Nickel, and Cobalt Alloys
- ASTM E581-17A(2022)e1 Standard Test Methods for Chemical Analysis of Manganese-Copper Alloys
- ASTM E672-87(2019)e1 Standard Specification for Disposable Glass Micropipets
- ASTM E729-23e1 Standard Guide for Conducting Acute Toxicity Tests on Test Materials with Fishes, Macroinvertebrates, and Amphibians
- ASTM E74-18e1 Standard Practices for Calibration and Verification for Force-Measuring Instruments