解锁多个用户被锁定的表
DECLare str VARCHAR2(1000);
BEGIN
FOR c1 in (SELECT username FROM dba_users /*+ 筛选条件*/ ) LOOP
str:='alter user '||c1.username||' account unlock';
EXECUTE IMMEDIATE str;
END LOOP;
END;
解锁多个用户被锁定的表
DECLare str VARCHAR2(1000);
BEGIN
FOR c1 in (SELECT username FROM dba_users /*+ 筛选条件*/ ) LOOP
str:='alter user '||c1.username||' account unlock';
EXECUTE IMMEDIATE str;
END LOOP;
END;