create or replace procedure proc_name as
cur1 is select * from table1;
begin
for rc in cur1 loop
update table2 set name=rc.name where id=rc.id;
end loop;
end;
请问rc不用定义吗?
...全文
372打赏收藏
一个最简单的游标使用问题
一个最简单的游标: create or replace procedure proc_name as cur1 is select * from table1; begin for rc in cur1 loop update table2 set name=rc.name where id=rc.id; end loop; end; 请问rc不用定义吗?