yqling2008 发表于 2013-1-14 08:56:03

Oracle 循环插入测试数据

declare
    maxrecords constant int:=1000;
    i int :=1;
begin
    for i in 1..maxrecords loop
      insert into UserInfo(UserID,login,password,firstName,lastName,ISADMINISTRATOR)
       values(SYS_GUID(),TO_CHAR('9999'+i),'password','fristname','lastName','0');
    end loop;
dbms_output.put_line(' 成功录入数据！ ');
commit;
end;
 
--SYS_GUID()  生成 GUID ORACLE
--NEWID   生成 GUID  SQLSERVERR
 
declare                                                                                                                 --定义部分标识
 maxrecords constant int:=100;                                                                           --定义 maxrecords 为整型常量 100
 i int :=1;                                                                                                              --定义 i 为整型值变量，初值为 1
Begin                                                                                                                    --执行部分标识
 for i in 1..maxrecords loop                                                                                   --i 从 1 循环到 maxrecords
 Insert into tempuser.testtable(recordnumber,currentdate) values (i,sysdate); --向数据表中插入数据
 end loop;                                                                                                            --结束循环
dbms_output.put_line(' 成功录入数据！ ');                                                             --显示成功录入数据信息
commit;                                                                                                                --提交结果
end;                                                                                                                     --结束执行
 
转自:
http://www.blogjava.net/zhyiwww/archive/2006/08/04/47679.html
页: [1]
查看完整版本: Oracle 循环插入测试数据