SQL> spool change_pwd.sql
SQL> select 'alter user ' || username || ' identified by eagledb123;'
  2  from dba_users where account_status = 'EXPIRED';

'ALTERUSER'||USERNAME||'IDENTIFIEDBYEAGLEDB123;'
-------------------------------------------------------------------
alter user SYSMAN identified by eagledb123;
alter user DBSNMP identified by eagledb123;

SQL> @change_pwd.sql