select
'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 username='PEACOCK';
Save user password
Categories:
Related Post
How To Enable The New Unified Auditing In 12c ? (Doc ID 1567006.1)How To Enable The New Unified Auditing In 12c ? (Doc ID 1567006.1)
GOAL A newly created 12c database might have Unified Au […]
How to use the RANGE function?How to use the RANGE function?
You can define this in one extract group or multiple ex […]
Merge Into和Update效率比较Merge Into和Update效率比较
from: https://www.cnblogs.com/eastsea/p/4519759.html 以前 […]