declare
cursor c1 is select u.usercode,u.logincode from user u where u.valid='1';
n1 number;
begin
for v1 IN c1 loop
update user G set G.Logincode= v1.logincode where g.usercode = v1.usercode;
end loop;
dbms_output.put_line(n1);
end
Oracle匿名块
最新推荐文章于 2022-03-10 16:49:28 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)