oracle批量插入数据

//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;