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;
?
我的异常网推荐解决方案:oracle存储过程,http://www.myexception.cn/oracle-develop/177537.html