Oracle SQL Pattern Matching Made Easy

Track

Razvoj i Middleware

Datum i vrijeme

petak, 15. listopad 2021., 12:15

Dvorana

Dvorana D

Trajanje

45'

Which countries have won 2 or more years in a row in the Eurovision Song Contest? As we'll see, this can be answered easily using SQL Pattern Matching.    A new clause ? MATCH_RECOGNIZE ? was added to the SELECT statement in Oracle 12c, to allow recognizing patterns in sequences of rows.    This new capability is very powerful, and introduces a completely new (yet somewhat intimidating) syntax. It allows solving a variety of problems in a simpler way than before, and with better performance.    The purpose of this entertaining and educating session is to explain the MATCH_RECOGNIZE feature from the basics, step-by-step, with many examples, and by that demonstrating how powerful and useful it is, and at the same time eliminating the fear from what may seem at first as complex syntax.

Detalji o predavanju

Način održavanja: Osobno prisustvo
Vrsta: Predavanje
Razina težine: Srednje detaljno
Poželjna funkcija slušatelja: Programeri
Grupa aktivnosti: Razvoj i Middleware

O predavaču

Najbolji pokrovitelj

Edukacijski pokrovitelj

Medijski pokrovitelj

HrOUG.hr

Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.

Prati nas na Twitteru

Sve novosti i zanimljivosti vezane uz HrOUG 2018 objavljujemo na Twitteru!

Prati nas na Facebooku