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匿名块
最新推荐文章于 2023-09-14 01:23:45 发布