declare @arg int;
set @arg =1;
while arg<>500
(
insert into TMDR01(F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT)
VALUES( chenSeq.Nextval,'a','a','a','1',SYSDATE,1,'1',SYSDATE);
set @arg =@arg+1;
)这段话用ORACLE怎么写? ORALCE忘了
set @arg =1;
while arg<>500
(
insert into TMDR01(F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT)
VALUES( chenSeq.Nextval,'a','a','a','1',SYSDATE,1,'1',SYSDATE);
set @arg =@arg+1;
)这段话用ORACLE怎么写? ORALCE忘了
declare arg number:=0;
begin
loop
if arg>= 500 then
exit;
end if;
arg :=arg+1;
insert into TMDR01(F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT)
VALUES( chenSeq.Nextval,'a','a','a','1',SYSDATE,1,'1',SYSDATE);
end--好像是这样的
--使用while 循环
declare arg number:=0;
begin
while arg <=500 loop
arg :=arg+1;
insert into TMDR01(F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT)
VALUES( chenSeq.Nextval,'a','a','a','1',SYSDATE,1,'1',SYSDATE);
end loop;
end
begin
if arg>= 500 then
exit;
end if;
arg :=arg+1;
insert into TMDR01(F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT)
VALUES( chenSeq.Nextval,'a','a','a','1',SYSDATE,1,'1',SYSDATE);
end
declare
arg integer:=0;
begin
loop
if arg>= 500 then
exit;
end if;
arg :=arg+1;
insert into TMDR01(F001,F002,F003,F004,F005,F006,F007,UPDID,UPDDT)
VALUES( chenSeq.Nextval,'a','a','a','1',SYSDATE,1,'1',SYSDATE);
end loop;
end;