Tabibitosan for Consecutive SQL problems

Save yourself from painful cross-joins and lag/lead window functions

Photo by Aswathy N on Unsplash

A google search of “tabibitosan sql” surprisingly returned only links from articles years ago. Even though since Oracle 12c, match_recognize is available to replace tabibitosan method, I felt that it’s still valuable to raise awareness of this technique both to solve problems in…