A b s t r a c t 

Presenter: Galo Balda
Organization: Texas Health and Human Services Commission
Biographical Sketch: Galo Balda is a talented Oracle database engineer and software developer working for the State of Texas, where he specializes in the design and performance of the Medicaid applications. Galo possesses multiple Oracle certifications and has presented before at RMOUG Training Days and ODTUG Kscope.
Title: SQL Pattern Matching in Oracle 12c
Summary: 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.
Topic: Application Development
Target Audience: All
Location: 501

RMOUG Training Days 2014
2520 Independence Blvd., Suite 201, Wilmington, NC 28412

Conference Administration Tool | Copyright © 2015, Prairie Systems Group, Limited