SET TERMOUT OFF COLUMN passWord NOPRINT NEW_VALUE current_password SELECT password FROM dba_users WHERE username = UPPER('&&username'); SET TERMOUT ON ALTER USER &&username IDENTIFIED BY &&temp_pass; CONNECT &&username/&&temp_pass -- 执行Sql命令 -- 如select * from tab;
PAUSE Press ENTER to reset the password back to what is was. ALTER USER &&username IDENTIFIED BY VALUES '&¤t_password';
