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
Merge Into和Update效率比较Merge Into和Update效率比较
from: https://www.cnblogs.com/eastsea/p/4519759.html 以前 […]
Goldengate replicat优化Goldengate replicat优化
By 徐靖 from:https://cloud.tencent.com/developer/article/ […]
Oracle Database 12c: PSUs vs database proactive bundle patchesOracle Database 12c: PSUs vs database proactive bundle patches
转载： by Simon Pane June 14, 2016 https://blog.pythian.co […]