INCITS 500-2012

INCITS 500-2012

Information technology - Database Language SQL - Row Pattern Recognition (SQL/RPR)



This standard specifies SQL language syntax and semantics that permit applications to identify row
pattern matches by using extended regular expressions applied to rows of base and derived tables. A
key component of this standard is the use of row pattern variables that span subsequences of rows,
defined using conditions on individual rows and on aggregates of rows. The primary syntax element
defined in this standard is the MATCH_RECOGNIZE clause, which is applied to table expressions.

Additional Info

Author InterNational Committee for Information Technology Standards (formerly NCITS)
Published by INCITS
Document type Standard
Number of pages 111
Replace INCITS 500 Draft
Keyword INCITS 500-2012
ANSI Approved