Tally table - equivalent of "select * from dual" in oracle

This sql query genrates unlimited sequential rows/virtual rows, using CTE

; WITH

Table1 AS (SELECT 1 N UNION ALL SELECT 1 N),    -- 2            ,              2 raise to power 1

Table2 AS (SELECT 1 N FROM Table1 x, Table1 y),            -- 8            ,   2 raise to power 3

Table3 AS (SELECT 1 N FROM Table2 x, Table2 y),            -- 128         ,   2 raise to power 7

Table4 AS (SELECT 1 N FROM Table3 x, Table3 y),            -- 32768        , 2 raise to power 15

Table5 AS (SELECT 1 N FROM Table4 x, Table4 y),           -- 2147483648 , 2 raise to power 31

tally as

(

                   SELECT

                             ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) N                      

                   FROM

                             Table1 , Table2 , Table3, Table4 --, Table5

                             -- you can delete or add tables here to increase decrease the rows, or

)

select * from tally where n < 5000

-- you can control number of rows here also