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.
| American National Standards Institute, Inc. (ANSI) | |
|---|---|
| Product Category | Standards and Technical Documents |
| Product Number | INFORMATION TECHNOLOGY - DATABASE LANGUAGE SQL - ROW PATTERN RECOGNITION (SQL/RPR) |
| Product Name | ANSI INCITS 500 Standard Document |