Oracle存储过程批量插入数据create or replace procedure query_tab01 asicount numberbegin----- 10条数
Oracle存储过程批量插入数据
create or replace procedure query_tab01 as icount number;begin ----- 10条数据 for k in 1 .. 10 loop insert into t (t1, t2) values ('t1_' || to_char(k), 't2_' || to_char(k)); end loop; commit;end;