On: Avoiding “OR” for Better Query Performance

[eximius]

Is there no equivalent to https://dba.stackexchange.com/questions/86724/how-to-create-... outside postgres to join against?

[cafard → eximius]

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.