Cart
0
Product
Products
(empty)
No products
To be determined
Shipping
$0.00
Total
Product successfully added to your shopping cart
Quantity
Total
There are 0 items in your cart.
There is 1 item in your cart.
Total products
Total shipping
To be determined
Total
Reduced price!
View larger
View larger
INCITS/ISO/IEC TR 19075-1
New product
INCITS/ISO/IEC TR 19075-1 11th Edition, January 1, 2011 Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL (Technical Report)
More info
Description / Abstract:
This Technical Report describes the regular expression support in SQL adopted from the regular expression syntax of [XQuery FO], which is derived from Perl. This Technical Report 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.
— 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.