Database 12c MATCH_RECOGNIZE: Beating the Best Pre-12c Solutions
Starting from common problems facing SQL developers, this session will show how the MATCH_RECOGNIZE clause provides more straightforward and efficient solutions than pre-12c methods such as analytics or the MODEL clause. Some of the problem areas covered are:
- grouping sequences;
- grouping based on intervals or running totals;
- and bin fitting problems.
These real-life examples will illustrate both basic and advanced syntax, with a focus on regular expressions.
Attendees will learn how to think of common problems in terms of pattern matching; how to discern problem types that the MATCH_RECOGNIZE clause can help solve; and how to work around some limitations, including the major pitfall of regular expressions: catastrophic backtracking.