Tiêu chuẩn quốc tế

• Số hiệu / Standard Number: ANSI INCITS 500:2012
• Năm ban hành / Publication date: 2012
• Tình trạng / Status: A - Còn hiệu lực
• Tên tiếng Anh / Title in English: Information Technology – Database Language SQL – Row Pattern Recognition (SQL/RPR)
• Số trang / Page: 111

Phạm vi áp dụng / Scope of standard

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.