||The ability to find, analyze, and quantify individual or groups of patterns within a data set is now a key business requirement.
The Oracle Database already supports the discovery of simple patterns through the use of features such as the LIKE operator and regular expressions. For more sophisticated pattern matching requirements, developers have been forced to write complex code that involves a lot of data movement that increases the complexity of performance optimizations, increases data latency, and reduces data security.
Oracle 12c provides a completely new native SQL syntax that uses the power of regular expressions to allow inter-row pattern search capability.
In this session, we’ll explore the new 12c MATCH_RECOGNIZE construct that allows us to define patterns in terms of characters or sets of characters, and provides the ability to search for those patterns across rows.