Abstract
Oracle Database 12c introduced row pattern matching, where it is possible to analyze patterns in sets of data. The match_recognize clause implements this. To a certain extent, analytic functions can also be used to do some rudimentary pattern matching, but it has its limitations. Other workarounds to find patterns in a sequence of rows were difficult to write, often hard to understand, and inefficient to execute. The match_recognize clause solves these problems using native SQL to allow pattern detection in data sets.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2023 The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature
About this chapter
Cite this chapter
Nuijten, A., Barel, P. (2023). Finding Patterns. In: Modern Oracle Database Programming. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-9166-5_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-9166-5_4
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-9165-8
Online ISBN: 978-1-4842-9166-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books