Oracle SQL Pattern Matching Made Easy
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 somewhat intimidating) syntax. It allows solving a variety of problems in a simpler way than before, and with better performance.
In this session we’ll focus on this new feature, understand its syntax (and see that it’s not as difficult as it seems), learn how to use it and see many useful examples.