clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36227 in the last week).

select max(case when mod(lvl, 2) = 0 then periods end) start_date, max(case when mod(lvl, 2) = 1 then periods end) end_date from ( select regexp_substr ('|2020/04/26|2020/05/02|2020/05/03|2020/05/10', '[^|]+', 1, level) as periods, level - 1 as lvl from dual connect by level <= length (regexp_replace('|2020/04/26|2020/05/02|2020/05/03|2020/05/10', '[^|]+')) ) t group by trunc(lvl / 2)
START_DATE END_DATE
2020/04/26 2020/05/02
2020/05/03 2020/05/10
 hidden batch(es)