Skip to Content
Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
book

Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

by Alex Nuijten, Patrick Barel
February 2023
Intermediate to advanced
588 pages
9h 13m
English
Apress
Content preview from Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_4

4. Finding Patterns

Alex Nuijten1   and Patrick Barel2
(1)
Oosterhout, Noord-Brabant, The Netherlands
(2)
Almere, Flevoland, The Netherlands
 

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services
QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Practical Oracle SQL: Mastering the Full Power of Oracle Database

Practical Oracle SQL: Mastering the Full Power of Oracle Database

Kim Berg Hansen
Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional
Oracle PL/SQL Programming: Fundamentals to Advanced
Oracle DBA Fundamentals

Oracle DBA Fundamentals

Robert G. Freeman

Publisher Resources

ISBN: 9781484291665Purchase LinkPublisher Website