Razvoj i Middleware
petak, 15. listopad 2021., 12:15
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.