The PASSWORD command allows you to change your Oracle password using SQL*Plus, and is described in Chapter 2.
PASSW[ORD] [username
]
where:
May be abbreviated to PASSW.
Is the user whose password you want to change. Usually only database administrators (DBAs) can change passwords for other users. You do not need to supply a username if you are changing your own password.