oracle 存储loop

2024/5/9 0:19:21

oracle 存储loop,oracle 写存储过程有返回值时 注意在loop循环处添加返回值:=

例子:create or replace procedure p_xl isv_count NUMBER(10);beginfor rs in(select yhbh from dbyh) loopv_count : osm_pkg_arc_limited_configs.F_LIMITED_METERS_CREATE(‘rs.yhbh‘,10001,---限量用水idsysdate,201706,0.00,10000);end loop;commit;end p_xl…