Split a string using REGEXP and CONNECT BY


You have a string of tokens separated by a char, here is how to split it using
regexp and connect by to return a table usable in a WHERE IN conditionMore...

Generating table of intervals (1,10),(11,20),...,(101,200),...,(1001,2000),...

It's often useful to present statistical results by interval representing frequencies but not necessarily evenly spaced,
example with (task, person) associations,
how many persons with only 1 task, with 2 to 10, with 11 to 20, … with 101 to 200, …
More...

Merging date intervals with MATCH_RECOGNIZE

Merging date intervals is a classical and potentially costly operation in the general case where intervals may overlap.
Here is a simple code pattern using
match_recognize More...