SQL statement to unlock and unexpire Oracle users

unlock_unexpire_users.sql

select 'alter user "'||username||'" account unlock;' || chr(10) ||
 'alter user "'||username||'" identified by values ''temp'';' || chr(10) ||
'alter user "'||username||'" identified by values '''||extract(xmltype(dbms_metadata.get_xml('USER',username)),'//USER_T/PASSWORD/text()').getStringVal()||''';' old_password 
from dba_users
where account_status != 'OPEN';