In Oracle SQL / PLSQL a user’s password can be changed using ALTER command.
Syntax for changing the user password using ALTER command in Oracle SQL / PLSQL is:
ALTER USER user_name
IDENTIFIED BY new_password;
ALTER USER techhoney IDENTIFIED BY pwdhoney;
Here we have changed the password for “techhoney” user as “pwdhoney”.