Generating Records from DUAL

How meny times You need to generate a test with a million of rows os some exaxt number of rows,


A trick that a friend told me is, 

Just use Dual,


select *
  from dual
connect by level <=:p_number_of_rows;

With this you have all the rows that you could need whithout a single insert.

Hope it helps.