1805050

ISO/IEC TR 19075-1:2011

Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL

standard by International Org. for Standardization/International Electrotechnical Commission (Technical Report) , 07/15/2011

This document has been replaced. View the most recent version.

View all product details

Historical

Track It

Language:
    • Available Formats
    • Options
    • Availability
    • Priced From ( in USD )
    • Printed Edition
    • Ships in 1-2 business days
    • $171.00
    • Add to Cart

Customers Who Bought This Also Bought

Identical Versions Available

 

About This Item

 

Full Description

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.
 

Product Details

Published:
07/15/2011
File Size:
1 file , 200 KB
Same As:
ISO/IEC TR 19075-1:2011
 

Document History

  1. ISO/IEC 19075-1:2021


    Information technology - Guidance for the use of database language SQL - Part 1: XQuery regular expressions

    • Most Recent

  2. ISO/IEC TR 19075-1:2011

    👀 currently
    viewing


    Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL

    • Historical Version