创建表和填充表

create table typeTab(c_id number(10),

                    c_name varchar2(100) not null);
declare

         i number(10);

begin

         for i in 1..100000

         loop

                   insert into typeTab values( i,'test' || i );

                   if i mod 100 = 0 then

                            commit;

                   end if;

         end loop;

 

end;