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;
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;
|
结束执行
|