where username specifies the user. If omitted, username defaults to the current user.
To change the password of another user, you must have been granted the appropriate privilege. See CONNECT for more information about changing your password.
If you want to change your current password, enter
PASSWORD Changing password for your_password Old password: your_password New password: new_password Retype new password: new_password Password changed
If you are logged on as a DBA, and want to change the password for user johnw (currently identified by johnwpass) to johnwnewpass
PASSWORD johnw Changing password for johnw New password: johnwnewpass Retype new password: johnwnewpass Password changed
Passwords are not echoed to the screen, they are shown here for your convenience.