全部博文
-
编辑 删除
在存储过程中执行3种oracle循环语句
create or replace procedure pr_zhaozhenlong_loop is i int; begin i :=1; loop insert into tb_zhaozhenlong(rpt_date ,dept_id,item,qty) values(to_date('2007-01-01','yyyy-MM-dd'),'D'||i,'I'||i,round(i*100/3,3)); exit when i =10; i :=i+1; end loop; &nb
