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.
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