set long 150
set linesize 150
set longchunksize 150

select 'alter user '||username||' identified by values '||REGEXP_SUBSTR(DBMS_METADATA.get_ddl 
('USER',USERNAME), '''[^'']+''')||';' from dba_users