To change a user’s password, including your own:

alter user THEUSERNAME identified by “NEWPASSWORD“;