Finding Patterns
Alex Nuijten, Patrick Barel · Apress eBooks · 2023
Oracle Database 12c introduced row pattern matching, where it is possible to analyze patterns in sets of data. The match_recognize clause implements this. To a certain extent, analytic functions can also be used to do some rudimentary pattern matching, but it has its limitations. Other workarounds to find patterns in a sequence of rows were difficult to write, often hard to understand, and inefficient to execute. The match_recognize clause solves these problems using native SQL to allow pattern detection in data sets.