Oracle 显示游标
<div id="cnblogs_post_body">create or replace procedure 显示游标更新as
--select taid, taname, bqid from table3
new_taid number;
cursor cur_tableis --显示声明游标
select taid from table3 where taid < 10
for update of taid; --taid在<10的范围之内进行锁定
c_row cur_table%rowtype; --返回行的数据
begin
open cur_table;
loop
fetch cur_table into new_taid;
exit when cur_table%notfound;--遍历之前进行判断，不为空进行更新
update table3 set taid=1+new_taid--taid > 10 并且出现重复的值就不在累加
where current of cur_table; --锁定的游标
dbms_output.put_line('taid=:' ||new_taid);
end loop;
close cur_table;
commit;
end 显示游标更新;
页:
[1]