oralce 批量操作demo
create table tab
(
a numeric,
b varchar2(50)
);
declare temp varchar2(20):=To_char(sysdate, 'HH24MISS');
i number;
begin
for i in 30..40 loop
insert into tab(a,b) values(i,temp||i);
end loop;
end;
select To_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual
select * from tab
drop table tab