Missing Numbers (Between two numbers)

[DaPi]

Do either of the above allow for a gap of two or more?

How about:

Select * From 
(SELECT :v_lower + ROWNUM AS missing_number
 FROM ALL_OBJECTS, ALL_OBJECTS
 WHERE ROWNUM < :v_upper - :v_lower)
Where missing_number not in 
(select my_col from my_table
 where  my_col is not NULL);

With aknowledgements to Jurij.

P.S: just noticed we need 100'000 numbers! Hope this won't blow the temp area!