Using SQL Pattern Matching with Big Data Lite VM

In this video, you are shown how to use SQL Pattern Matching with the Big Data Lite VM.

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:

1. Logically partition and order the data that is used in the MATCH_RECOGNIZE clause with its PARTITION BY and ORDER BY clauses.
2. Define patterns of rows to seek using the PATTERN clause of the MATCH_RECOGNIZE clause. These patterns use regular expressions syntax, a powerful and expressive feature, applied to the pattern variables you define.
3. Specify the logical conditions required to map a row to a row pattern variable in the DEFINE clause.
4. Define output measures, which are expressions usable in the MEASURES clause of the SQL query.
5. Control the output (summary vs. detailed) from the pattern matching process

See the Oracle By Example demo at: https://apex.oracle.com/pls/apex/f?p=44785:24:0:::24:P24_CONTENT_ID,P24_PREV_PAGE:9540,1
See the related blog post at http://oracle-big-data.blogspot.co.uk/2014/04/analyzing-our-big-data-lite-movie-app.html

Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.