File Library

Uses of Row Pattern Matching
Topic: Webinars
Owner: Kim Berg Hansen
Date: 2020-08-06

Kim Berg Hansen, Trivadis

With 12c came the ability to search efficiently for patterns within your rows of data using a syntax similar to searching for character patterns in strings with regular expressions, but instead of searching text, it searches for data patterns.

This is useful for pattern recognition like finding ups and downs in values over time (e.g., stock tickers) or transaction patterns in accounts that may look like fraudulent behavior. But it can also be used for grouping consecutive data, finding gaps, finding or merging overlapping periods, calculating number of children in hierarchical data, and more.

Join me for a discussion of different use cases of row pattern matching.

Download File   Uses of Row Pattern Matching Kim Berg Hansen Trivadis.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database