Sometimes Oracle developer needs to present multiple values by selecting multiple rows. Using one of the existing tables can do the trick, but it can be resource consuming. Example below shows how to do the same using DUAL with its single row:
select 'x',level from dual a
connect by level < 10
Just change 10 to whatever number of rows you need.
