Declare
workDate DATE := sysdate - 1;
d DATE := sysdate;
idSession NUMBER := 2200000000;
idSearch NUMBER := 2200000000;
idEvent NUMBER := 2200000000;
valueSessionValue NUMBER := 2200000000;
Begin
d := workDate;
d := d + 6000/(24*60*60);
for i in 1..80000 LOOP
d := d + 6/(24*60*60);
idSession := idsession + 1;
idSearch := idSearch + 1;
INSERT INTO xxxx(
ID,
USER_REF,
GROUP_REF,
REFERER_REF,
BEGIN_TIME,
END_TIME,
SERVER_REF,
USER_IP )
VALUES(
idSession,
3440,
746,
1,
d,
d+1/(24*60*60),
1,
'202.221.112.142');
if MOD(i,5000)=0 then
commit;
end if;
end LOOP;
end;
/