Generate sequence with connect by
/* Formatted on 3/11/2022 11:52:32 am (QP5 v5.388) */
SELECT LEVEL + 99
FROM DUAL
WHERE LEVEL NOT IN (2, 4)
CONNECT BY LEVEL <= 6;
SELECT LEVEL
FROM DUAL
WHERE LEVEL NOT IN (3, 10)
CONNECT BY LEVEL <= 10;
SELECT criteria
FROM DUAL
MODEL
DIMENSION BY (0 criteria)
MEASURES (0 x)
RULES
(x [FOR criteria FROM 100 TO 105 INCREMENT 1] = 0);