ANSI INCITS 500
Information Technology – Database Language SQL – Row Pattern Recognition (SQL/RPR)
active, Most Current
Buy Now
| Organization: | ANSI |
| Publication Date: | 16 October 2012 |
| Status: | active |
| Page Count: | 111 |
scope:
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.
Document History
ANSI INCITS 500
October 16, 2012
Information Technology – Database Language SQL – Row Pattern Recognition (SQL/RPR)
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...