Friday, 8 February 2019

How to create fast a table with 1 million rows

  create table test1
  as
  select rownum rn, mod(rownum,1000) mod1 ,  mod(rownum,90) mod2
 from dual
 connect by level <=1000000;


No comments:

Post a Comment