4 ms·
How about select x, y from (select -1 * (rownum - 1) as x from all_objects where rownum <= 10000), (select rownum as y from all_obj
by cafard 7y ago
How about
select x, y
from
(select -1 * (rownum - 1) as x
from all_objects
where rownum <= 10000),
(select rownum as y
from all_objects
where rownum <= 100)
Wrap it in another SELECT * FROM () if you wish.