Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL to do the following:
Duration: 30 minutes
This content is intended for the following job role(s): PL/SQL Developer, Data Warehouse Developer, Business Analyst, Application Developer
Release Date: 08-MAY-2014
Created by: Keith Laker
This series features an OBE and a recorded webcast. Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improves application and development productivity and query efficiency for row-sequence analysis.
Release Date: 12-NOV-13