How to Change Password in Oracle using Oracle SQL developer ?

If want to change the old password of your oracle database user, then you can easily do it by the following SQL command: SQL Command Syntax:

1	ALTER user user_name identified by new_password replace old_password;

Example: Let, existing oracle user name = shafiq & password=abc123, then you to change the password of shafiq user, the correct SQL command is:

1 2 3 4 5

ALTER user shafiq IDENTIFIED by "new_password123" REPLACE "abc123";

Type the command on you SQL developer command SQL Worksheet or any other Database Tools you currently use.

Change password in oracle

Oracle SQL Developer Handbook (Oracle Press)