一个选项是编写一个查询，它将为您编写查询。例如：

SQL> select 'alter user ' || username || ' account unlock;' from dba_users;

'ALTERUSER'||USERNAME||'ACCOUNTUNLOCK;'
---------------------------------------------------------
alter user SUPERUSER account unlock;
alter user C##TEST account unlock;
alter user SYS account unlock;
alter user SYSTEM account unlock;
alter user ANONYMOUS account unlock;
alter user SUSHANT account unlock;
alter user SCOTT account unlock;
<snip>

现在，复制/粘贴上面的一组 ALTER USER 你就能解开所有人的锁。
另一个是一个简单的pl/sql块，它使用动态sql（我只解锁用户scott；你想解锁谁就解锁谁）。

SQL> begin
  2    for cur_r in (select username from dba_users where username in ('SCOTT')) loop
  3      execute immediate 'alter user ' || cur_r.username || ' account unlock';
  4    end loop;
  5  end;
  6  /

PL/SQL procedure successfully completed.

SQL>