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
Sale!
View larger
View larger
ANSI INCITS 500
New product
ANSI INCITS 500 2012 Edition, October 16, 2012 Information Technology – Database Language SQL – Row Pattern Recognition (SQL/RPR)
More info
Description / Abstract:
INCITS 500-2012 specifies the syntax and semantics of database
language facilities that support row pattern matching using regular
expressions.
The database language facilities that support row pattern recognition include:
- A subset of regular expression syntax.
- Row pattern variables that span subsequences of rows, defined using conditions on individual rows and on aggregates of rows.
- A major new syntax element, the MATCH_RECOGNIZE clause, that can be applied to table expressions and can be used in definitions of windows.
The database language facilities that support row pattern recognition include:
- A subset of regular expression syntax.
- Row pattern variables that span subsequences of rows, defined using conditions on individual rows and on aggregates of rows.
- A major new syntax element, the MATCH_RECOGNIZE clause, that can be applied to table expressions and can be used in definitions of windows.