How to calculate the longest and current consecutive streaks with Oracle SQL - #JoelKallmanDay
Blog: Oracle BPM
An explanation of how to find streaks - a consecutive series of events - using SQL pattern matching in Oracle Database. For example, the number of consecutive days users logged in, their winning streaks or they completed a task.