American National Standards Institute, Inc. (ANSI) ANSI INCITS 500 Standard Document INFORMATION TECHNOLOGY - DATABASE LANGUAGE SQL - ROW PATTERN RECOGNITION (SQL/RPR)

Description
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.
Description
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.

Suppliers

Company
Product
Description
Supplier Links
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.

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.

Supplier's Site

Technical Specifications

  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
Unlock Full Specs
to access all available technical data

Similar Products