oracle数据库批量解锁表

解锁多个用户被锁定的表

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;