oracle 存储过程循环执行update语句

其实二楼写的最简单，但对于新手，最好别那么写，至于1楼，如果数据不是很多，没必要搞个游标。你也可以看看我写的

create or replace procedure P_Update(o_vc_message out varchar2)
is
type column1 is table of table1.column1%type index by binary_integer;
col1s column1;
type rid is table of rowid index by binary_integer;
rids rid;
temp table1.column1%type;
begin
select column1,rowid bulk collect into col1s,rids from table1;
if (column1.count != 0) then
for i in col1s.first..col1s.last loop
temp := col1s(i);--处理 col1s(i) 想干嘛干嘛
update table1 set column1 = temp where rowid = rids(i);
end loop;
end if;
o_vc_message := 'OK!';
exception
when others then
o_vc_message := 'exception happend.' || sqlcode || sqlerrm;
rollback;
return;
end P_Update;

如果仅仅是简单处理column1，比如加1什么的，就别搞那么复杂，一个sql就ok了。

create or replace procedure TESTis
begin
--遍历记录 for table1model in (select column1 from table1) loop --更新列(当前值加1) update table1 set column1=table1model.column1+1 where column1=table1model.column1; end loop;
commit;exception when others then rollback; return;
end TEST;

找出主键，用游标可以完成！但特殊处理是哈，说清楚我写个例子出来