Lecture Type

45-60 minutes presentation

Abstract

A new clause – MATCH_RECOGNIZE – was added to the SELECT statement in Oracle 12c, to allow recognizing patterns in sequences of rows.

This new capability is very powerful, and introduces a completely new (yet rather complex) syntax.

In this session we’ll focus on this new feature, understand its syntax, learn how to use it and see many useful examples.