sql | easy to generate 'loop ranges'?
need a column starting 1 to 100:
SELECT LEVEL SL_NO
FROM DUAL
CONNECT BY LEVEL <= 100;
what about dates, from a date to a date?
SELECT TO_DATE(:from_date, 'DD-MON-RRRR') + LEVEL - 1 SL_NO
FROM DUAL
CONNECT BY LEVEL <= (TO_DA...
0xweathered.hashnode.dev1 min read