Select multiple rows from dual (connect by)

 9i

select l from (select  level l from dual connect by level <= 10);

10g onwards

select level l from dual connect by level <= 10; 

Bonus SQL Server version 

with r as (
	select 1 n union all 
	select r.n+1 from r where r.n+1 <= 10
)
select n from r ;