SQL> create table t1 (id number(10),name varchar(20)); Table created. SQL> begin for i in 1 .. 1000000 loop insert into t1 values(i,'yy'); end loop; commit; end; /