nobody Have a Question? Help Login
  • Home
  • Content Details

Using SQL Pattern Matching - Series

Would you recommend this content?
9 user(s) recommend this content
  • 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.

  • 25-Jun-13
  • Database 12c SQL and PL/SQL OBEs

Content List (click links below to view content)

24-JUL-2013

Introduction to SQL Pattern Matching in Oracle Database 12c - Video Series

Oracle Product Manager, Keith Laker, demonstrates how to work with SQL Pattern Matching in Oracle Database 12c in this three-part video series. See Keith's blog for more information.

25-JUN-2013

Using SQL Pattern Matching

In this OBE, you 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.

07-MAY-2014 60 mins

Big Data Lite Movieplex Demo - SQL Pattern Matching for Sessionization Analytics

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:

  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
08-MAY-2014 30 mins

Big Data Lite Movieplex Video Demo - SQL Pattern Matching for Sessionization Analytics

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:

  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
01-NOV-2013 35 mins

Using SQL for Pattern Matching in Oracle Database - (Recorded Webcast Event)

Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improve application and development productivity and query efficiency for row-sequence analysis.Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL.

Please Log In to Bookmark this OBE

Bookmarked 7 times

 
9 user(s) recommend this content

Hide/Show Reviews

sanjay 1.1 years ago
I have reading this event first
  • Login to add a reply

Hide/Show Additional Resources

Information about Related Products