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
What is RBA and checkpoint in GoldenGate?What is RBA and checkpoint in GoldenGate?
The relative byte address (RBA) is the location within […]
PRAGMA EXCEPTION_INIT的用法PRAGMA EXCEPTION_INIT的用法
如果要处理未命名的内部异常，必须使用OTHERS异常处理器或PRAGMA EXCEPTION_INIT 。PR […]
《收获，不止SQL优化》 – 调优信息一键生成脚本《收获，不止SQL优化》 – 调优信息一键生成脚本
转：https://cloud.tencent.com/developer/article/1415749 梁 […]