插入大批量数据的脚本

declare
   totalrow integer := 1;
      begin
  while totalrow <= 100000 loop
     insert into _THE_TEST ("TESTID","ENTITYID","ELEMENTTYPE","ID","ACTION","RESULTTYPE","RESULT","ERRORDESCRIPTION")
     values ('TEST_MSG_20131223'||totalrow,'0','TESTING','PROG/'||totalrow||'@TEST.TEST','TEST','1','0','');
     totalrow := totalrow + 1;
  end loop;
end;