nobody Have a Question? Help Login
  • Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improve application and development productivity and query efficiency for row-sequence analysis.Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL to do the following: - Logically partition and order the data that is used in the MATCH_RECOGNIZE clause with its PARTITION BY and ORDER BY clauses - Define patterns of rows to seek using the PATTERN clause of the MATCH_RECOGNIZE clause. These patterns use regular expressions syntax, a powerful and expressive feature, applied to the pattern variables you define. - Specify the logical conditions required to map a row to a row pattern variable in the DEFINE clause. - Define measures, which are expressions usable in the MEASURES clause of the SQL query.

Join Supriya Ananth

Supriya Ananth is a Curriculum Developer in Oracle, working with the Database Application Development team. Supriya has been involved with training and education since 2011. Supriya has worked extensively with the SQL and PL/SQL courses. Recently, she completed a rewrite of the "Analytic SQL for Data Warehousing" course and a series of Oracle By Example tutorials for .NET.

This event took place already.

Please take a moment and take our survey.