//time是date类型,id和name是varchar2类型
declare i number;
begin
for i in 1…100 loop
insert into employ (id, name, time) values (concat(‘id’,i), ‘myname’,sysdate);
end loop;
end;
最后提交
查询当前时间:select sysdate from dual;
03-14
1695
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
//time是date类型,id和name是varchar2类型
declare i number;
begin
for i in 1…100 loop
insert into employ (id, name, time) values (concat(‘id’,i), ‘myname’,sysdate);
end loop;
end;
最后提交
查询当前时间:select sysdate from dual;