select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c
from dba_users d, sys.user$ u
where d.username = upper('&&username')
and u.user# = d.user_id;
source:
「你未必要做出豐功偉績,但請至少為自己找回/發掘對生活中一些事情的熱情,不要再計較這件事能給你多少利益和著數,讓自己拾回朝氣和目標已是最佳回報。」(amoeba 100)
select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c
from dba_users d, sys.user$ u
where d.username = upper('&&username')
and u.user# = d.user_id;